Problem in closing connection in postgresql

[anoopprasad]

Hi,
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.


Thanks

Anoop Prasad

[debasisdas]

That seems to be a problem with application software not database.

[Pramod Gautam]

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.