Re: [GENERAL] Postgres Win32
Hi, You would see my page about PostgreSQL 7.0.3 on WinNT: http://people.freebsd.org/~kevlo/postgres/portNT.html - Kevin Dan Wilson wrote: > >From an earlier posting last week: > > -- > Sorry for the website is not accessble that time but now it can be > access at this url http://208.160.255.143 > > this include an easy installation of PostgreSQL v.7.0.2 for windows > 98,2000 and NT. there is a pg guardian that automatically start and setup > ur server and many more...:) hope you like this piece of program > > ian > --- > > I downloaded and installed it on my Win2K server just to see if it worked. > It seemed to work ok, but I couldn't connect to it with PHP. I didn't do a > lot of troubleshooting though. > > -Dan > > - Original Message - > From: carolina > To: [EMAIL PROTECTED] > Cc: María José Ravazzani ; Federico Peña ; Alfredo Sánchez > Sent: Friday, December 15, 2000 12:20 PM > Subject: [GENERAL] Postgres Win32 > > We are a group of students of the University ORT from Uruguay. We are making > our final project, so we can graduate of Programming Analysts. After an > exhaustive research, we decided to use Postgres in our system, because we > realised that it is the most suitable DB for it. The problem is that the > company we are working for, doesn't have a Linux net, so our question is: > Can Postgres run in Windows 95 or Windows 98? And how we can do it? > You can write to us to: > [EMAIL PROTECTED] , [EMAIL PROTECTED] or [EMAIL PROTECTED] > or to our tutor: [EMAIL PROTECTED] > thanks ver much for your help > P/D: Sorry about the mistakes!!!
Re: [GENERAL] Tuning Database
Joseph Shraibman wrote: > Anand Raman wrote: > > > > there is a white paper present on the great bridge site > > (http://www.greatbridge.com/) where u can find some tuning tips . > > Where, persactly? http://www.greatbridge.com/download/gbpg70wp2.pdf > -- > Joseph Shraibman > [EMAIL PROTECTED] > Increase signal to noise ratio. http://www.targabot.com - Kevin -- À
[GENERAL] 'Pg' is what we called DBI?
Hi, I want to use Perl with DBI(DataBase Independent Interface) to write cgi scripts. In /src/interfaces/perl5 directory, I found Pg. But my friend told me that Pg isn't DBI. Now I'm confused. Pg is DBI or not? If not, how can I install Postgres DBI? -Kevin.
[GENERAL] Postgres' DBI(Pg) problems.
Hi,
I'm trying to use Postgres DBI, which is Pg, to write a simple cgi script.
But I encounter a problem, hope anyone can tell me how to do, thanks.
For example:
I have two input forms in ex.html, which names are 'id' and 'student'.
I want to insert them into 'course' table in student database by using Pg.
The script I wrote as following:
#!/usr/local/bin/perl
require 'forms-lib.pl';/* this script gets form values in HTML that I input */
use DBI;
print "Content-type: text/html\n\n";
print "\n";
print "\n";
print "Data inserted\n";
print "\n";
%input = &GetFormInput();
$v1 = $input{'id'};
$v2 = $input{'student'};
$dbh = DBI->connect("dbi:Pg:dbname=student") or die $DBI::errstr;
$sth = $dbh->prepare("insert into course values('$v1', '$v2')")
or die $DBI::errstr;
$sth->execute or die $DBI::errstr;
print "\n";
print "Data inserted!\n";
print "\n";
print "\n";
After executing this script, I just see brower's title "Data inserted",
I can't see "Data inserted!" in HTML and can't insert values into 'course'
table. I don't know how to do, would anyone tell me, thanks in advance.
Best regards,
Kevin.
Re: [GENERAL] Info required about RDM Database
Dinesh Patil wrote: > Hi, Hi, Dinesh, > I am working on Postgres currently but we will be replacing postgres with > another database for advanced features and different platforms like Windows > NT > where postgres cannot be used. You can port PostgreSQL to NT :) please see my page: http://members.tripod.com/~kevlo/postgres/portNT.html Hope this helps, Kevin.
Re: [GENERAL] IPC Problems - URGENT !
Anthony Brock wrote: > I am in a similar position to the person below. I am trying to install > Postgres 6.5beta3 on a Solaris 7 machine (64-bit libraries installed) using > egcs-1.1.2 and receive the following when trying to run the 'postmaster -i' > command: > > IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, > size=1073152, permission=600 > FATAL 1: ShmemCreate: cannot create region > > Does anyone have some pointers on how to fix this? Or any idea what the > problem is? Thanks in advance, Using ipcs to list shared resources, ipcrm to remove one. The id is the number listed under shmid by ipcs. > Tony -- Kevin Lo| Linpus Technologies Inc. [EMAIL PROTECTED] | http://www.linpus.com.tw
Re: [GENERAL] Trouble with Innstalling PostGreSQL 6.5.2 on Win NT
Jeff Hoffmann wrote: > on a related note, i've been thinking about trying out postgres on NT, > but i've been hesitant to do so because it seems to be a "just because i > can" port -- maybe not as stable or fast as on a unix system, but neat > to have. are people actually using it for serious (ie, it needs to be > reliable but not necessarily mission critical) work? Hi, Jeff, I know Postgres on NT is not as stable as on a UN*X system so far. Some friends of mine works on NT platform, they just want to learn SQL, but you know, almost databases on NT are commercial, they are expensive and they cannot pay it just because they want to learn SQL, right? Now they can run PostgreSQL on NT, and study more fun :-) Becuase Postgres is *free* and *open source*, so that's why I port PostgreSQL to NT. > jeff -- `""""""' Kevin Lo "Use the Internet to|| [EMAIL PROTECTED] it's fullest potential" OO--)| [EMAIL PROTECTED] \__ (_| [EMAIL PROTECTED] /\ || http://www.freebsd.org/~kevlo(=(_>< \
Re: [GENERAL] Trouble with Innstalling PostGreSQL 6.5.2 on Win NT
Oleg Broytmann wrote: > On Fri, 1 Oct 1999, Kevin Lo wrote: > > Some friends of mine works on NT platform, they just want to learn SQL, > > but you know, almost databases on NT are commercial, they are expensive > > and they cannot pay it just because they want to learn SQL, right? > >If you know (or agree to learn) Python programming language I cannot > resist to recommend you to try Gadfly. It is SQL engine written entirely in > Python, and thus it is portable to any platform where python exists > (DOS/Windows/UNIX/Mac/etc). It is free, it is small and simple, but > powerful enough to use it even in commercial projects. To speed things up > some internal parts had been rewritten in C, but I don't know how this work > on NT (on UNIX it is pretty good). > >http://www.chordate.com/gadfly.html Hi, Oleg, Thanks for the info. It's very cool!! Well, I believe you're a Python guru :-) > > > jeff > > Oleg. > > Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED] >Programmers don't die, they just GOSUB without RETURN. -- Kevin LoWahoo International Enterprise Co.,Ltd. [EMAIL PROTECTED] http://www.wahoo.com.tw
[GENERAL] Announce: PostgreSQL-6.5.3 binaries available for Windows NT
Hi, Some people asked me to build PostgreSQL binaries for Windows NT. The binaries(PostgreSQL-6.5.3) are now available at: ftp://203.79.167.135/pub/postgres-nt-binaries.tar.gz Please go to my page if you want to build it yourself :) http://www.freebsd.org/~kevlo/postgres/portNT.html The Chinese version is at: http://www.freebsd.org/~kevlo/postgres/portNT_Big5.html Enjoy! Kevin.
[GENERAL] Re: [ANNOUNCE] Announce: PostgreSQL-6.5.3 binaries available forWindows NT
Hannu Krosing wrote: > Kevin Lo wrote: > > > > Hi, > > > > Some people asked me to build PostgreSQL binaries for Windows NT. > > The binaries(PostgreSQL-6.5.3) are now available at: > > > > ftp://203.79.167.135/pub/postgres-nt-binaries.tar.gz > > Great ! > > > Please go to my page if you want to build it yourself :) > > > > http://www.freebsd.org/~kevlo/postgres/portNT.html > > > > The Chinese version is at: > > > > http://www.freebsd.org/~kevlo/postgres/portNT_Big5.html > > > > And could someone please put a note about them on www.postgresql.org ? > > I searched it on Sunday for just this and I could only find a link to > the last url - the chinese translation ;( Seems you don't read the FAQ :) See http://www.postgresql.org/docs/faq-english.html#1.4 > --- > Hannu - Kevin
[GENERAL] Re: [INTERFACES] Announce: PostgreSQL-6.5.3 binaries available forWindows NT
Tusar wrote: > Does the binary contain sql server with it? Sure. Please run "psql -h hostName template1". > Tusarkanti Nayak > @Communicators > Phone: 91 - 11 - 5535770(O) > Phone: 91 - 11 - 5613992(O) > Phone: 91 - 11 - 5528098(R) > Fax: 91 - 11 - 5613991 > URL: http://tusar.netshooter.com > Mail:<[EMAIL PROTECTED]> > * > ** You never know what is enough until you > you know what is more than enough *** > * > DeVries' Dilemma: > If you hit two keys on the typewriter, the one you don't want > hits the paper. Enjoy! Kevin.
Re: [GENERAL] DBI::Pg for Perl?
Peter Berghold wrote: > Hi Folks, > Does anyone out there know of a DBI driver for Postgres for Perl? I > searched CPAN and didn't see one. Maybe I'm looking in the wrong > spot... It's at : http://www.perl.com/CPAN-local/modules/by-module/DBD/DBD-Pg-0.93.tar.gz > -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- > +-+ > Peter L. Berghold[EMAIL PROTECTED] > "Linux renders ships http://www.berghold.net > NT renders ships useless" - Kevin
Re: [GENERAL] DBI::Pg for Perl?
Peter Berghold wrote: > Thanks! I was looking in the wrong spot! Did a search of CPAN with > the key DBI::* and didn't see DBD::Pg. DOH! Right. I also couldn't find DBD::Pg if I search that key. > Building it right now. Good luck, Kevin.
Re: [GENERAL] Announce: PostgreSQL-6.5.3 binaries available forWindows NT
Robert wrote: > Kevin Lo wrote: > > > Some people asked me to build PostgreSQL binaries for Windows NT. > > The binaries(PostgreSQL-6.5.3) are now available at: > > > > ftp://203.79.167.135/pub/postgres-nt-binaries.tar.gz > > Hi, Hi, Robert, > I'm trying this on Win98 (cygwin b20.1): initdb creates template1 just > fine (I had to run it as sh initdb), but whenever I try to run > postgres.exe, > it complains > > FATAL 1: Database system does not exist. PGDATA > directory '/usr/local/pgsql/data' not found > > even if two minutes ago it worked and the directory is there of course. > Some funny problem with mount? Any help will be greatly apreciated. mount? You can't run psql server on Windows 98 platform. The PostgreSQL doesn't generate pq.dll if you notice it. > - Robert - Kevin
