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 <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/
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
