Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 0999047681D
	for <pgsql-sql@postgresql.org>; Wed,  4 Dec 2002 18:24:49 -0500 (EST)
Received: from localhost.localdomain (unknown [65.217.53.66])
	by postgresql.org (Postfix) with ESMTP id A3CDC476719
	for <pgsql-sql@postgresql.org>; Wed,  4 Dec 2002 18:23:27 -0500 (EST)
Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100])
	by localhost.localdomain (8.12.5/8.12.5) with ESMTP id gB4NWG6P014815;
	Wed, 4 Dec 2002 18:32:16 -0500
Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55])
	by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id gB4NNMj15835;
	Wed, 4 Dec 2002 18:23:22 -0500
Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP
	(Microsoft Exchange Internet Mail Service Version 5.5.2653.13)
	id XX5JWLTP; Wed, 4 Dec 2002 18:23:21 -0500
Subject: Re: Ran out of connections
From: Robert Treat <xzilla@users.sourceforge.net>
To: Steve Crawford <scrawford@pinpointresearch.com>
Cc: Mike Diehl <jdiehl@sandia.gov>, pgsql-sql@postgresql.org
In-Reply-To: <20021204222925.51EF4103C6@polaris.pinpointresearch.com>
References: <20021204220457.94E2778E6@dominion.dyndns.org>
	<20021204222925.51EF4103C6@polaris.pinpointresearch.com>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.8 
Date: 04 Dec 2002 18:23:21 -0500
Message-Id: <1039044201.8617.241.camel@camel>
Mime-Version: 1.0
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/59
X-Sequence-Number: 10647

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,
>