[OGo-Users] postgres connection limit exceeded

[Helge Hess]

On 01.03.2008, at 07:47, Sebastian Reitenbach wrote:
> 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.


Having more instances doesn't raise the number of sessions (hence open  
channels), they are load balanced, thats the idea after all. Each of  
the servers will have less channels open.

Helge
-- 
Helge Hess
http://www.helgehess.eu/