Message-Id: <200209070925.g879Pgt31252@delorie.com> Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm List-Subscribe: List-Archive: List-Post: List-Help: , 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> 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/