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

Problem in closing connection in postgresql

P: 1
My name is Anoop. I am working in a call center as a trainee system administrator. We are using postgresql as a database of asterisk dialer server in our center . But after every two or three months a problem comes in the database. As connections created to the database doesn't get close immediately with the request as a result of this large number of connections is build and the load on the database server increases then system hangs and then suddenly all connections get closed. This process repeated regularly.

Please anyone can tell the solution of this problem.


Anoop Prasad
Feb 18 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 5K+
P: 8,127
That seems to be a problem with application software not database.
Feb 19 '08 #2

P: 4
I think , this is not a problum of database. Because when anyone close thier application cthe connection betwwen that database also close automatically. One more way for close datbase that is you run "exit" query from your application. I think this will help you.
Mar 11 '08 #3

Post your reply

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