Csaba Nagy <nagy@xxxxxxxxxxxxxx> 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
