From: Mike Diehl <jdiehl@sandia.gov>
To: Roberto Mello <rmello@cc.usu.edu>
To: Mike Diehl <jdiehl@sandia.gov>
Cc: pgsql-sql@postgresql.org
Subject: Re: Ran out of connections
Date: Wed, 4 Dec 2002 16:52:58 -0700
Message-ID: <20021204234919.CA46678E6@dominion.dyndns.org> (raw)
In-Reply-To: <20021204222538.GD30716@cc.usu.edu>
References: <20021204220457.94E2778E6@dominion.dyndns.org>
<20021204222538.GD30716@cc.usu.edu>
On Wednesday 04 December 2002 03:25 pm, Roberto Mello wrote:
> On Wed, Dec 04, 2002 at 03:08:35PM -0700, Mike Diehl wrote:
> > 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
>
> Are you using PHP by chance? I've seen this behavior under Apache+PHP
> before. My "fix" (workaround rather) was to disable persistent
> connections.
Nope. I'm using Perl and cgi. I've got some perl that runs via cron, and
some more that runs via apache. I'm not even using ModPerl.
It did occur to me that since some of my scripts communicate with other
devices, that I may have some IO blocking, or zombies, but the ps output
didn't indicate that. I can't see that many scripts running. Usually, I see
one postgres process for each script/cgi that is running. Not in this case.
--
Mike Diehl
Network Tools Devl.
SAIC at Sandia Labs
(505) 284-3137
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: jdiehl@sandia.gov, rmello@cc.usu.edu
Subject: Re: Ran out of connections
In-Reply-To: <20021204234919.CA46678E6@dominion.dyndns.org>
* 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