Re: killing idle attaches without killing others

From: John R Pierce <pierce(at)hogranch(dot)com>
To: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: killing idle attaches without killing others
Date: 2010-08-04 14:37:25
Message-ID: 4C597B25.7070101@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 08/04/10 7:03 AM, Gauthier, Dave wrote:
>
> Hi:
>
> 8.3.4 on Linux
>
> 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?
>
>

kill the programs that are making those idle connections.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-08-04 14:46:24 Re: hashtable issue - HASH_FIND??
Previous Message Guillaume Lelarge 2010-08-04 14:27:32 Re: killing idle attaches without killing others