Re: postgres help

Wow. I'm glad that worked for you. I'd tried that and it didn't work for me. - Original Message - From: "Jason House" <[EMAIL PROTECTED]> To: "Jonathan Simms" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, August 25, 2003

Re: postgres help

that *relies* on 2.x. Let me know how it works out for you. - Original Message - From: "Jason House" <[EMAIL PROTECTED]> To: "Jonathan Simms" <[EMAIL PROTECTED]> Sent: Monday, August 25, 2003 8:51 AM Subject: Re: postgres help I did get 1.14-1 from the site,

Re: postgres help

ms" <[EMAIL PROTECTED]> Sent: Monday, August 25, 2003 8:51 AM Subject: Re: postgres help > I did get 1.14-1 from the site, but did not uninstall 2.x. Could that > be causing a problem? > > Jonathan Simms wrote: > > > Oh, one more thing, I found that the latest ver

Re: postgres help

Igor, On Mon, Aug 25, 2003 at 01:51:24PM -0400, Igor Pechtchanski wrote: > Umm, Jason (Tishler), you might want to change the service management > section in the docs to use "cygrunsrv -S", "cygrunsrv -E" and > "cygrunsrv -Q" (for query). These work just as well as "net start" > and "net stop", a

Re: postgres help

Jason, On Mon, Aug 25, 2003 at 01:10:59PM -0400, Jason House wrote: > Thanks for the help everyone (Jason, Igor and Jonathan) You are welcome. > #2 did solve the problem. Thanks for the confirmation! > I have also upgraded the cygwin version to 1.5 which was probably > another problem. Yes:

Re: postgres help

Umm, Jason (Tishler), you might want to change the service management section in the docs to use "cygrunsrv -S", "cygrunsrv -E" and "cygrunsrv -Q" (for query). These work just as well as "net start" and "net stop", and cygrunsrv has an additional benefit of being pty-aware, so it should always pro

Re: postgres help

Thanks for the help everyone (Jason, Igor and Jonathan) #2 did solve the problem. I have also upgraded the cygwin version to 1.5 which was probably another problem. Now all I have to do is figure out how to use postgres ;) Some recommended doc improvements (to prevent questions from people lik

Re: postgres help

Jason, On Mon, Aug 25, 2003 at 11:30:51AM -0400, Jason House wrote: > [EMAIL PROTECTED] ~ > $ cat /var/log/postmaster.log > IpcSemaphoreInitialize: semctl(id=2, 0, SETVAL, 0) failed: Invalid argument > LOG: startup process (pid 2548) exited with exit code 1 > LOG: aborting startup due to startup

Re: postgres help

Ok, through the assistance of others and my own poking around, I have progressed further. I did have a pre 1.5 version of cygwin... I guess that I naively assumed performing an update would ensure that I had 1.5. Here is the current attempt: [EMAIL PROTECTED] ~ $ cat /var/log/postmaster.log ca

Re: postgres help

Jason, "uname" or "uname -a" should let you know the version of the Cygwin DLL. Also, "cygcheck -c cygwin" will tell you the version of the "cygwin" package that you have installed. FYI, according to you would have done well to attach (that is, *attach* as an att

Re: postgres help

I'm sorry, I forgot to mention that I did verify that /tmp/.s.PSQL.5432 was not present. As far as version of cygwin, I don't know how to check it. I did run setup within the past week. It should be an up to date version. Jason Tishler wrote: Jason, On Fri, Aug 22, 2003 at 07:12:33PM -0400,

Re: postgres help

Jason, On Fri, Aug 22, 2003 at 07:12:33PM -0400, Jason House wrote: > I don't understand why I'm getting the following error: > > $ psql -U postgres template1 > psql: could not connect to server: No such file or directory > Is the server running locally and accepting > connections

Re: postgres help

Hey, i just went through this myself. When you start the service make sure you give the argument "-i", it'll turn on TCP/IP networking. next set the environment variables: PGDATA= "/path/to/data/folder/" PGDATABASE = "your_dbname" PGHOST = "localhost" PGPASSWORD = password PGPORT = "5432" PGUSER

Re: postgres help

Jason House wrote: I've gone through all the steps to set up postgreSQL on windows XP. I have updated permissions (to /tmp /usr/bin /usr/bin/*), verified the system path variable, and verified that ipc and postmaster services have been started. I don't understand why I'm getting the followin

RE: postgres help

> > I've gone through all the steps to set up postgreSQL on windows XP. I > have updated permissions (to /tmp /usr/bin /usr/bin/*), verified the > system path variable, and verified that ipc and postmaster services have > been started. I don't understand why I'm getting the following error: > > $