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
Date: Sat, 07 Sep 2002 15:47:41 -0400
From: Jason Tishler <jason AT tishler DOT net>
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 AT cygwin DOT com
Mail-followup-to: cygwin AT cygwin DOT 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 AT lmg DOT ahnet DOT net>
 <20020906172515 DOT GI1964 AT tishler DOT net> <E17nZmd-00083T-00 AT quimby DOT gnus DOT org>
 <02Sep7.022547-0700_pdt.290634-25802+89 AT lmg DOT ahnet DOT net>

On Sat, Sep 07, 2002 at 11:21:49AM +0200, news AT garydjones DOT mailshell DOT com wrote:
> 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?!?

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 AT postgresql DOT 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/