Re: Canceling other backend's query

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: daq <daq(at)ugyvitelszolgaltato(dot)hu>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Canceling other backend's query
Date: 2003-08-27 15:31:12
Message-ID: Pine.LNX.4.33.0308270930410.1338-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Faulkner 2003-08-27 19:49:12 length of array
Previous Message Richard A. DeVenezia 2003-08-27 15:30:24 Q: Multicolumn lookup, Join or Sub-query ?