This is a commonly requested feature by DBA's migrating from SQL Server and Oracle. In those databases, there is a GUI to monitor database requests, and potentially kill them to resolve deadlocks or runaway queries (though, in the case of SQL server, it does not work). Right now, it is very difficult for any of our GUI projects to construct such an interface due to the necessity of root shell access.
Yes, MySQL can do it too.
http://www.mysql.com/doc/en/KILL.html
I would love to have a KILL <pid> command in postgres. I don't know how you would restrict it to only being able to kill postgres backends though.
Chris
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
