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

From Gauthier, Dave
Subject killing idle attaches without killing others
Date
Msg-id 482E80323A35A54498B8B70FF2B87980046602C861@azsmsx504.amr.corp.intel.com
Whole thread Raw
Responses Re: killing idle attaches without killing others  (Vick Khera <vivek@khera.org>)
Re: killing idle attaches without killing others  (John R Pierce <pierce@hogranch.com>)
List pgsql-general

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?

 

Thanks !  

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: Postgresql database procedures?
Next
From: Vick Khera
Date:
Subject: Re: killing idle attaches without killing others