I have a custom publisher class for persistent database connection,
based on this wiki page: http://www.quixote.ca/qx/ReusingConnections. I
use it with PostgreSQL, psycopg and SCGI server. But there must be
something wrong with my code, because after a while the process list is
full of postgres connections, some of them "idle", some "idle in
transaction". The application keeps running fine (I think), but every
attempt to make a new connection (for example, from a cron script)
falls with an error: "FATAL, Sorry, too many clients already". Looks
like maximum number of connections is reached... unused connections not
being closed?

I realize that it is not a Quixote problem, but was hoping someone with
the same configuration can give an advise -- like, where (and how) to
debug?!

Thanks in advance...

Ksenia.