[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