Re: Function to kill backend

> 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