Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner@cygwin.com Mail-Followup-To: cygwin@cygwin.com Delivered-To: mailing list cygwin@cygwin.com Date: Sat, 07 Sep 2002 15:47:41 -0400 From: Jason Tishler Subject: Re: Postgres - more questions (was: Re: [Postgres] initdb - does it ever finish?!?) In-reply-to: <02Sep7.022547-0700_pdt.290634-25802+89@lmg.ahnet.net> To: cygwin@cygwin.com Mail-followup-to: cygwin@cygwin.com Message-id: <20020907194741.GQ1964@tishler.net> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT Content-disposition: inline User-Agent: Mutt/1.4i References: <02Sep6.101215-0700_pdt.292221-5504+21@lmg.ahnet.net> <20020906172515.GI1964@tishler.net> <02Sep7.022547-0700_pdt.290634-25802+89@lmg.ahnet.net> On Sat, Sep 07, 2002 at 11:21:49AM +0200, news@garydjones.mailshell.com wrote: > 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?!? Did you export PGDATA? > More worryingly: > $ pg_ctl stop -D /cygdrive/k/pgsql/data > waiting for postmaster to shut > down............................................................ > .... 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... > http://sources.redhat.com/ml/cygwin/2001-05/msg00774.html > 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 pgsql-cygwin@postgresql.org -- someone there may be able to help. Jason -- 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/