Re: Killing only one postmaster

I think there is only one postmaster and multiple backends.

To cancel the query being executed by a particular backend pid
use

kill -INT <pid_of_the_backend>
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(at)postgresql(dot)org

-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/