[OGo-Users] postgres connection limit exceeded

[Sebastian Reitenbach]

users@opengroupware.org wrote: 
> > Anyways, I think PG forks a process per connection, this might have  
> > some cost associated. But I doubt it will become an issue unless you  
> > go 1000+.
> 
> I found -
> http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=497
oh, this is very interesting, especially as all the users are LDAP 
authenticated. also the mentioned default there:

Defaults write NSGlobalDomain PGMaxOpenConnectionCount 200
however, I think this is per instance. On one host, I have snsd running 
serving 10 ogo instance, so these 10 instances together could then use up to 
2000 database connections. 
Then, with my 200 maximum connections configured in postgres, this is by far 
not enough. So I assume I should raise it to something like 3000 to be safe.

cheers
Sebastian