Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruce Momjian
Subject Re: Canceling other backend's query
Date
Msg-id 200308271446.h7REkNI25884@candle.pha.pa.us
Whole thread Raw
In response to Canceling other backend's query  (daq <daq@ugyvitelszolgaltato.hu>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: How to return a record set from function.
Next
From: Richard Huxton
Date:
Subject: Re: How to return a record set from function.