[OGo-Users] postgres connection limit exceeded

Sebastian Reitenbach users@opengroupware.org
Fri, 29 Feb 2008 14:39:12 +0100


Hi,

as the company grows, more and  more people are using ogo. From time to time 
it happens that people that try to login, get an error message, ogo cannot 
reach its database. Users with an already active session, can still work. I 
figured out, that the postgres database had its connection limit exceeded. 
Raising the connection limit fixes the problem for a while, but I don't 
think that this is the best idea, if good at all.
Well, after googling for a solution to the problem, the recommended answer 
is either fix the application, or use a connection pooling daemon like 
pgbouncer. 
Is there an ogo default, allowing me to kill idle database sessions?
Or anybody uses such a postgresql connection pooling daemon in conjunction 
with OGo?

cheers
Sebastian