Hi all.
Twice this week, I've come to work to find my Postgres server out of
connections... effectively freezing my web server.
Today, before I rebooted the entire system, I did a ps -auxw and kept the
file to study. I didn't find too many clients running. But I did find a
whole LOT of
On Wed, Dec 04, 2002 at 03:08:35PM -0700, 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.
Today, before I rebooted the entire system, I did a ps -auxw and kept the
file to study. I didn't
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.
I suspect you need to look carefully at your code and method of connecting
(ie. are you using mod-perl, plain old cgi perl, PHP or
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
Doing anything unusual? Forking processes, opening multiple connections
within a single CGI?
Have you seen any evidence that a process that opens a connection is failing
to complete normally?
-Steve
On Wednesday 04 December 2002 3:52 pm, Mike Diehl wrote:
On Wednesday 04 December 2002 03:25