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(at)yahoo(dot)com> wrote in message
>news:9a41d107(dot)0304110640(dot)374e1dd(at)posting(dot)google(dot)com(dot)(dot)(dot)
> > 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(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly