We are running PostgreSQL 7.2.2 (7.4.1 in a few weeks). We have a pesky legacy application which periodically leaves open idle connections. (I know... fix the application). In the short term, I would like to find out if the database engine has a time-out configuration option for idle connections where it would force-close the connections.
Is there such an option?
...john
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend