[horde] PostgreSQL connection limit problem

[Daniel A. Ramaley]

On Monday 20 March 2006 14:50, Eric Jon Rostetter wrote:
>Quoting "Daniel A. Ramaley" <daniel.ramaley at DRAKE.EDU>:
>> Mar 13 19:31:36 sun12 postgres[20954]: [1-1] FATAL:  connection
>> limit exceeded for non-superusers
>
>Make your postgresql connection limit at least as great as your httpd
>children limit.

That's easy enough to do. Thanks for the tip. I'll keep an eye on the 
server for awhile to make sure this fixes it.

PostgreSQL's limit was initially set to 100. I set it to 256, which is 
what Apache's MaxClients was set to. I seriously doubt we had 100 
simultaneous users on the system before, but maybe Apache holds onto 
connections longer than it needs to and hit the limit that way.

------------------------------------------------------------------------
Dan Ramaley                            Dial Center 118, Drake University
Network Programmer/Analyst             2407 Carpenter Ave
+1 515 271-4540                        Des Moines IA 50311 USA