This is the mail archive of the
cygwin@cygwin.com
mailing list for the Cygwin project.
Postgres - more questions (was: Re: [Postgres] initdb - does it ever finish?!?)
- From: news at garydjones dot mailshell dot com
- To: cygwin at cygwin dot com
- Date: Sat, 07 Sep 2002 11:21:49 +0200
- Subject: Postgres - more questions (was: Re: [Postgres] initdb - does it ever finish?!?)
- References: <02Sep6.101215-0700_pdt.292221-5504+21@lmg.ahnet.net> <20020906172515.GI1964@tishler.net> <E17nZmd-00083T-00@quimby.gnus.org>
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/