Re: [SQL] Canceling other backend's query

2003-08-28 Thread Bruce Momjian
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

Re: [SQL] Canceling other backend's query

2003-08-28 Thread scott.marlowe
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

[SQL] Canceling other backend's query

2003-08-27 Thread daq
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 ---(end of broadcast)--- TIP 7: don't forget to increase your free spa