Message-Id:	<200209070925.g879Pgt31252@delorie.com>
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sources.redhat.com/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
X-Sent:	7 Sep 2002 09:25:15 GMT
X-Newsgroups:	gmane.os.cygwin
Subject:	Postgres - more questions (was: Re: [Postgres] initdb - does it ever finish?!?)
From:	news AT garydjones DOT mailshell DOT com
References:	<02Sep6.101215-0700_pdt.292221-5504+21 AT lmg DOT ahnet DOT net> <20020906172515 DOT GI1964 AT tishler DOT net> <E17nZmd-00083T-00 AT quimby DOT gnus DOT org>
User-Agent:	Xnews/4.11.09
X-No-Archive:	yes
To:	cygwin AT cygwin DOT com
X-Gate:	Hamster/1.3.23.185 NewsToMail-Gate
Date:	Sat, 07 Sep 2002 11:21:49 +0200

On 06 Sep 2002, news AT garydjones DOT mailshell DOT 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/

- Raw text -