This is the mail archive of the cygwin@cygwin.com mailing list for the Cygwin project.


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Postgres - more questions (was: Re: [Postgres] initdb - does it ever finish?!?)


On 06 Sep 2002, news@garydjones.mailshell.com wrote:

> Thanks for the advice, it works fine now (as far
> as I have taken it).

>From pg_ctl I get output like this:
$ pg_ctl stop  
pg_ctl: no database directory or environment variable $PGDATA is 
specified
Try 'pg_ctl --help' for more information.

and yet:
$ echo $PGDATA   
/cygdrive/k/pgsql/data

Huh?!?

More worryingly:
$ pg_ctl stop -D /cygdrive/k/pgsql/data
waiting for postmaster to shut 
down............................................................
.... failed
pg_ctl: postmaster does not shut down

I had to use 
kill -9 `head -1 /usr/local/pgsql/data/postmaster.pid`
in the end (/usr/local/pgsql being a symlink to my data area).

I see a similar report to the latter problem in the archives 
(http://sources.redhat.com/ml/cygwin/2001-05/msg00499.html) but 
http://sources.redhat.com/ml/cygwin/2001-05/msg00774.html 
suggests it was fixed (over a year ago). BTW, I wish I'd read 
those threads about six months ago, some of the information 
solved something I had to work out for myself at that time.

I forgot to ask before, btw - is there a recommended method of 
running it on W9x? The docs generally recommend starting it as 
user "postgres". Is it best to just add an entry to /etc/passwd 
(AIUI "mkpasswd" is not supported on W9x)? I am thinking of 
something like "postgres::42:99:::".

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]