Error: Sorry, too many clients already

  • Thread starter Thread starter osmarjunior
  • Start date Start date
O

osmarjunior

Hi,

I'm using ODBC to connect to the dbms (Postgresql v8.1, in Windows
server).

After a few program open/close I get the message "Sorry, too many
clients already". I believe my database class properly closes the
connection when it is removed. Maybe not.

How do I see how many connections there are?
How would I terminate orphaned connections? Is this possible?

Regards.

Junior.
 
Hi Junior,
make sure that your application is closing the connections every time.
Try to use using statement every it's possible.
If the problem persists, try to call GC.Collect() and
GC.WaitForPendingFinalizers() after closing the connections.

[]'s
Oberdan
 
Back
Top