I use kill -s SIGINT <pid of bad query> Thanks, Anjan
-----Original Message----- From: Brandon Hines [mailto:[EMAIL PROTECTED] Sent: Friday, May 13, 2005 2:32 PM To: [email protected] 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
