Re: Canceling other backend's query - Mailing list pgsql-sql

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.