From: Robert Treat <xzilla@users.sourceforge.net>
To: Steve Crawford <scrawford@pinpointresearch.com>
Cc: Mike Diehl <jdiehl@sandia.gov>
Cc: pgsql-sql@postgresql.org
Subject: Re: Ran out of connections
Date: 04 Dec 2002 18:23:21 -0500
Message-ID: <1039044201.8617.241.camel@camel> (raw)
In-Reply-To: <20021204222925.51EF4103C6@polaris.pinpointresearch.com>
References: <20021204220457.94E2778E6@dominion.dyndns.org>
<20021204222925.51EF4103C6@polaris.pinpointresearch.com>
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,
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: xzilla@users.sourceforge.net, scrawford@pinpointresearch.com, jdiehl@sandia.gov
Subject: Re: Ran out of connections
In-Reply-To: <1039044201.8617.241.camel@camel>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox