Re: Killing only one postmaster

It is even easier:
pg_ctl -D <directory> stop

and if you want to do it the hardcore way:
kill -TERM `head -n 1 <data dir>`

The problem with the ps command is probably that it may be hard to find out
which postmaster you are about to kill...
hence the directory approach...

Michiel
At 17:20 11-4-2003 -0700, codeWarrior wrote:
>Get the process id of your postmaster's...
>
># ps ax | grep postmaster
># kill (pidnumber of the seletcted postmaster)
>
>
>
>"Bo Stewart" <stewarrb@yahoo.com> wrote in message
>news:9a41d107.0304110640.374e1dd@posting.google.com...
> > How do I stop only one postmaster and not have the entire server
> > restart?  Is this possible.  I have had several situations where I
> > have a function not performing as I expect and need to kill just the
> > backend process.
> >
> >
> > Thanks,
> > Bo Stewart
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly