Re: Ran out of connections - Mailing list pgsql-sql

From Robert Treat
Subject Re: Ran out of connections
Date
Msg-id 1039044201.8617.241.camel@camel
Whole thread Raw
In response to Re: Ran out of connections  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-sql
Once your done scoping other things out, you might also want to look at
increasing the number of allowed connections (in postgresql.conf). The
defaults can be low for high traffic systems.

Robert Treat

On Wed, 2002-12-04 at 17:29, Steve Crawford wrote:
> You probably didn't need to reboot - I suspect you could have probably 
> restarted PostgreSQL and Apache (quick version) or killed the extra postgres 
> processes.
> 
<snip lots of good suggestions>
> 
> Cheers,
> Steve
> 
> 
> On Wednesday 04 December 2002 2:08 pm, Mike Diehl wrote:
> > Hi all.
> >
> > Twice this week, I've come to work to find my Postgres server out of
> > connections... effectively freezing my web server.
> >
<snip>
> >
> > Can anyone tell me how to fix this?  The out put of the ps command can be
> > seen at http://dominion.dyndns.org/~mdiehl/ps.txt
> >
> > Thanx in advance,
> 





pgsql-sql by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Ran out of connections
Next
From: Mike Diehl
Date:
Subject: Re: Ran out of connections