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