From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Vick Khera <vivek(at)khera(dot)org> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: killing idle attaches without killing others |
Date: | 2010-08-04 14:27:32 |
Message-ID: | 4C5978D4.10005@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Le 04/08/2010 16:18, Vick Khera a écrit :
> On Wed, Aug 4, 2010 at 10:03 AM, Gauthier, Dave <dave(dot)gauthier(at)intel(dot)com>wrote:
>
>> How can one kill just the <IDLE> processes I see attached to a DB (from
>> pg_stat_activity) without disturbing the others? If I need to kill the idle
>> pids one ata time, which signal_name should I use for that?
>>
>>
>>
>>
> Connected to psql as a superuser, issue SELECT pg_cancel_backend(PID); where
> PID is the pid of the process to close.
>
pg_cancel_backend doesn't kill anything. It stops a running query. But
there isn't any here as the connection is idle.
The OP needs pg_terminate_backend, but it only appears in 8.4. The only
thing to do is to upgrade to 8.4. Or fix the software that keeps idle
connections.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2010-08-04 14:37:25 | Re: killing idle attaches without killing others |
Previous Message | Dean Rasheed | 2010-08-04 14:26:25 | Re: killing idle attaches without killing others |