| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Joshua Tolley <eggyknap(at)gmail(dot)com> |
| Cc: | paulo matadr <saddoness(at)yahoo(dot)com(dot)br>, GENERAL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: idle users |
| Date: | 2009-03-06 02:48:13 |
| Message-ID: | dcc563d10903051848p2c5934abka69b0ae668b8942e@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Mar 5, 2009 at 9:31 AM, Joshua Tolley <eggyknap(at)gmail(dot)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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-03-06 02:57:47 | Re: idle users |
| Previous Message | Lubomir Petrov | 2009-03-06 02:17:19 | Re: Hiding row counts in psql |