Re: Killing only one postmaster

There can also be multiple backends... look for the PID you want to kill 
(SIGHUP or SIGTERM) in your $PGDATA/postmaster.pid file

Michiel
At 23:57 11-4-2003 +0530, mallah@trade-india.com wrote:


>I think there is only one postmaster and multiple backends.
>
>To cancel the query being executed by a particular backend pid
>use
>
>kill -INT 
>its equivalent to pressing ^C in psql for that query.
>
>regds
>mallah.
>
> > 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 1: subscribe and
> > unsubscribe commands go to majordomo@postgresql.org
>
>
>
>-----------------------------------------
>Get your free web based email at trade-india.com.
>    "India's Leading B2B eMarketplace.!"
>http://www.trade-india.com/
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)