On Wed, Aug 4, 2010 at 10:03 AM, Gauthier, Dave <dave.gauth...@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.