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

From Vick Khera
Subject Re: killing idle attaches without killing others
Date
Msg-id AANLkTim2S7X215HD+osoCGVz4tVbVyc0DX3EqJeLeZWc@mail.gmail.com
Whole thread Raw
In response to killing idle attaches without killing others  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Responses Re: killing idle attaches without killing others
Re: killing idle attaches without killing others
List pgsql-general
On Wed, Aug 4, 2010 at 10:03 AM, Gauthier, Dave <dave.gauthier@intel.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.

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: killing idle attaches without killing others
Next
From: Dean Rasheed
Date:
Subject: Re: killing idle attaches without killing others