By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,592 Members | 1,005 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,592 IT Pros & Developers. It's quick & easy.

Idle Connection force-close ?

P: n/a
Hi, all.

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

Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
On Thu, Feb 12, 2004 at 10:02:46AM -0800, John Gibson wrote:
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?


No. If the connection is live and idle, it'll sit there forever. If
the client is actually gone but the connection stays alive, then
tcp/ip will eventually shut it down.

A

--
Andrew Sullivan

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.