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

Idle connections not closing

P: n/a
I am having a postgresql database server and the idle connections are not closing themselves. They are increasing to large numbers as time passes and the web page is not loading. The code developer says that the code for closing these idleconnections are included in the code itself. But it is also not working. We have tried to close by giving several values to maxactive and maxidle. But none are working. I want to know whether there is a workaround for this issue and how these connections can be closed safely without restarting the server.
Nov 25 '10 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 700
The code developer says that the code for closing these idleconnections are included in the code itself.
So it seems this code is not working and somebody should fix it. I don't think there is a postgres option which will make postgres to close idle connections. If you use unix/linx system you can look for process with 'idle' tag and kill it but I don't think it is a good solution.
It should be fixed in code.
Nov 26 '10 #2

Expert 100+
P: 700
Use pgpool-II application. It has client_idle_limit config parameter.
Jan 10 '11 #3

Post your reply

Sign in to post your reply or Sign up for a free account.