Csaba Nagy <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster