On Thu, Mar 5, 2009 at 9:31 AM, Joshua Tolley <eggyknap@gmail.com> 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)