I use kill -s SIGINT <pid of bad query>
Thanks,
Anjan
-----Original Message-----
From: Brandon Hines [mailto:brandon@2i.com]
Sent: Friday, May 13, 2005 2:32 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Killing a Query
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.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org