pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCanceling other backend's query
3+ messages / 3 participants
[nested] [flat]
* Canceling other backend's query
@ 2003-08-27 09:12 daq <daq@ugyvitelszolgaltato.hu>
2003-08-27 14:46 ` Re: Canceling other backend's query Bruce Momjian <pgman@candle.pha.pa.us>
2003-08-27 15:31 ` Re: Canceling other backend's query scott.marlowe <scott.marlowe@ihs.com>
0 siblings, 2 replies; 3+ messages in thread
From: daq @ 2003-08-27 09:12 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Canceling other backend's query
2003-08-27 09:12 Canceling other backend's query daq <daq@ugyvitelszolgaltato.hu>
@ 2003-08-27 14:46 ` Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 0 replies; 3+ messages in thread
From: Bruce Momjian @ 2003-08-27 14:46 UTC (permalink / raw)
To: daq <daq@ugyvitelszolgaltato.hu>; +Cc: pgsql-sql
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, Pennsylvania 19073
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Canceling other backend's query
2003-08-27 09:12 Canceling other backend's query daq <daq@ugyvitelszolgaltato.hu>
@ 2003-08-27 15:31 ` scott.marlowe <scott.marlowe@ihs.com>
1 sibling, 0 replies; 3+ messages in thread
From: scott.marlowe @ 2003-08-27 15:31 UTC (permalink / raw)
To: daq <daq@ugyvitelszolgaltato.hu>; +Cc: 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-08-27 15:31 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-27 09:12 Canceling other backend's query daq <daq@ugyvitelszolgaltato.hu>
2003-08-27 14:46 ` Bruce Momjian <pgman@candle.pha.pa.us>
2003-08-27 15:31 ` scott.marlowe <scott.marlowe@ihs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox