[Pypgsql-users] Error: "Sorry, Too many clients already"

[Anthony D. <ad...@in...>]

Hi,

I am having some trouble when using the pypg interface to postgreSQL.

Every now and then (I haven't been able to isolate exactly when it 
happens) I encounter the error "Sorry, too many clients already." which 
I can only recover from by restarting postgres.

Postgres is using the default n=32 processes, which is much more than 
the number of connections I am aware of being made.  One of our 
applications using pypg runs as a cron job every 10 minutes, but all 
connections look as though they are being dropped at the end of each run 
(as expected).

Could this be a cursor issue? Could cursors remain on the server after 
my application finishes?  When should new cursors be used?  When should 
cursors be re-used for similar operations (e.g. a bunch of inserts).

Does pypg explicitly close all connections / cursors when it's instance 
is terminated?

Thanks, any insight would be greatly appreciated.

-Anthony