I use kill -s SIGINT <pid of bad query> Thanks, Anjan -----Original Message----- From: Brandon Hines [mailto:brandon@xxxxxx] Sent: Friday, May 13, 2005 2:32 PM To: pgsql-admin@xxxxxxxxxxxxxx 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
