Re: killing idle attaches without killing others - Mailing list pgsql-general

From John R Pierce
Subject Re: killing idle attaches without killing others
Date
Msg-id 4C597B25.7070101@hogranch.com
Whole thread Raw
In response to killing idle attaches without killing others  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List 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.



pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: killing idle attaches without killing others
Next
From: Tom Lane
Date:
Subject: Re: hashtable issue - HASH_FIND??