Re: Killing a Query - Mailing list pgsql-admin

From Brandon Hines
Subject Re: Killing a Query
Date
Msg-id 42850E14.2040505@2i.com
Whole thread Raw
In response to Killing a Query  (Brandon Hines <brandon@2i.com>)
List pgsql-admin
Brandon Hines wrote:
>
> Is there a method for killing a query from the server.
>
> I have a number of users that manage to run queries that busy the server
> preventing a number of critical queries from running within an
> acceptable time limit.
>
> I would like to kill off the queries that appear to be busying the
> server without having to take postgres down altogether.
>


I guess I should have read today's messages before posting.

Thanks, Anjan, for answering my question before I could ask it.

Kill -s SIGINT <pid of offending statement>

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: version 8.0.3
Next
From: "Lee Wu"
Date:
Subject: /tmp/.s.PGSQL.5432