Re: idle users

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)