Csaba Nagy <nagy@ecircle-ag.com> writes:
> And pg_stat will only show you running queries, not the idle
> connections.
Nonsense. pg_stat_activity + "kill -TERM" should solve this problem
reasonably well. Some of us don't trust kill -TERM 100%, which is why
it's not currently exposed as a standard function, but if you're using
a reasonably recent PG release it's probably safe.
regards, tom lane