On Thu, Mar 5, 2009 at 9:31 AM, Joshua Tolley <eggyknap@xxxxxxxxx> wrote: > On Thu, Mar 05, 2009 at 04:50:09AM -0800, paulo matadr wrote: >> I need to procedure to kill users in idle,anybody have this made? >> thanks > > See pg_cancel_backend. > http://www.postgresql.org/docs/8.3/static/functions-admin.html I just tried it and it didn't work. An idle in transaction connection ignored it. And I ran pg_cancel_backend as a superuser, getting back a 't' as a response. I think you gotta kill them from outside. Unless there's a pg_kill command I'm not familiar with. But then I'd have to make a view so I could pg_kill(all_humans); (bender joke for those that don't get it) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
