This is the mail archive of the
mailing list for the Cygwin project.
Re: Postgres - more questions (was: Re: [Postgres] initdb - does itever finish?!?)
- From: Jason Tishler <jason at tishler dot net>
- To: cygwin at cygwin dot com
- Date: Sat, 07 Sep 2002 15:47:41 -0400
- Subject: Re: Postgres - more questions (was: Re: [Postgres] initdb - does itever finish?!?)
- References: <02Sep6.firstname.lastname@example.org><20020906172515.GI1964@tishler.net> <E17nZmd-00083Temail@example.com><02Sep7.firstname.lastname@example.org>
On Sat, Sep 07, 2002 at 11:21:49AM +0200, email@example.com wrote:
> On 06 Sep 2002, firstname.lastname@example.org 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
> Try 'pg_ctl --help' for more information.
> and yet:
> $ echo $PGDATA
Did you export PGDATA?
> More worryingly:
> $ pg_ctl stop -D /cygdrive/k/pgsql/data
> waiting for postmaster to shut
> .... failed
> pg_ctl: postmaster does not shut down
Works for me:
$ pg_ctl stop -D /usr/share/postgresql/data
waiting for postmaster to shut down......done
postmaster successfully 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).
Never "kill -9" the postmaster -- use "kill 15" instead.
> I see a similar report to the latter problem in the archives
> (http://sources.redhat.com/ml/cygwin/2001-05/msg00499.html) but
The above is unrelated...
> suggests it was fixed (over a year ago).
and has been fixed.
> 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:::".
Sorry, I don't do the 9x/Me thing. I suggest trying
email@example.com -- someone there may be able to help.
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Bug reporting: http://cygwin.com/bugs.html