killing idle attaches without killing others

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: killing idle attaches without killing others
Date: 2010-08-04 14:03:26
Message-ID: 482E80323A35A54498B8B70FF2B87980046602C861@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 !

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2010-08-04 14:18:31 Re: killing idle attaches without killing others
Previous Message David Fetter 2010-08-04 13:45:58 Re: Postgresql database procedures?