On Wed, Aug 4, 2010 at 10:03 AM, Gauthier, Dave <dave(dot)gauthier(at)intel(dot)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.