Thread: Canceling other backend's query

Hi,

Can i cancel querys runing on other backends, or disconnect a client
from the server? I can kill the backend process, but sometimes this
causing shared memory troubles.

DAQ

On Wed, 27 Aug 2003, daq wrote:

> Hi,
> 
> Can i cancel querys runing on other backends, or disconnect a client
> from the server? I can kill the backend process, but sometimes this
> causing shared memory troubles.

If you kill -9 a backend, you will cause the shared memory problem.  Try 
just a plain kill <pid>.  That should work without causing shared memory 
to dump.

daq wrote:
> Hi,
> 
> Can i cancel querys runing on other backends, or disconnect a client
> from the server? I can kill the backend process, but sometimes this
> causing shared memory troubles.

See the 'postgres' manual page for a list of signals and their effects.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073