Re: shutdown postmaster question

--- George Weaver <gweaver(at)shaw(dot)ca> wrote:

>
> You might find starting and stopping postmaster
> easier by using pg_ctl. Eg
> in a batch file the following will stop the server:
>
> bash pg_ctl stop -D /usr/share/postgresql/data
>
> Regards,
> George
>
>
> ----- Original Message -----
> From: <operationsengineer1(at)yahoo(dot)com>
> To: <pgsql-novice(at)postgresql(dot)org>
> Sent: Wednesday, February 23, 2005 3:17 PM
> Subject: [NOVICE] shutdown postmaster question
>
>
> >i use the following commands to start the
> postmaster
> > on my development winxp / cygwin / pgsql 7.4.5
> > setup...
> >
> > 1.
> >
> > /usr/sbin/cygserver &
> >
> > 2.
> >
> > postmaster -i -D /usr/share/postgresql/data &
> >
> > before getting to my real question, what do the
> "&"
> > characters do?
> >
> > now to the real question... how do i shut down
> the
> > postmaster? i checked the docs bu it wasn't
> clear. i
> > tried their example and it didn't work.
> >
> > i read about the signals... SIGTERM, SIGINT, or
> > SIGQUIT, but i don't how to implement them since
> the
> > example given didn't work. any help woul dbe
> greatly
> > appreciated.
> >
> > i have been shutting down cygwin to end pgsql, but
> my
> > guess is that isn't the best way to shut it down.
> >
> > tia...
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Take Yahoo! Mail with you! Get it on your mobile
> phone.
> > http://mobile.yahoo.com/maildemo
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the
> unregister command
> > (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)

i tried pg_ctl with no luck. i started with

pg_ctl start

but my pgdata environment variable wasn't set and i
couldn't quickly find out how to set it via the docs.

i then tried

pg_ctl /usr/share/postgresql/data start

and received an invalid operation mode error.

i'm not sure how pg_ctl handles the "-i" issue (tcp/ip
connections) and whether the trailing "&" is required
using pg_ctl. the docs and my php/pgsql book were
unclear after an admittedly quick review.

__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail