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@postgresql.org
-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/
