> Otherwise, I'll stick by my assertion that idle connection management should > be done in the middleware and NOT by psql.
Perhaps it should be, but as PostgreSQL picks up more and more vendor applications this is difficult for the person administrating the database. Consider a 3rd party application which has the issue but the support contract is such that you cannot affect the application itself (their support staff deals with it). If you need connections in the database for other applications and this 3rd party program is idling on several slots... -- Rod Taylor <rbt [at] rbt [dot] ca> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL PGP Key: http://www.rbt.ca/signature.asc
signature.asc
Description: This is a digitally signed message part