too many clients

From: Matthew Terenzio <webmaster(at)localnotion(dot)com>
To: pgsql-php(at)postgresql(dot)org
Subject: too many clients
Date: 2004-12-29 15:05:18
Message-ID: 0DC9A380-59AB-11D9-B3B3-0003938BDF32@localnotion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

After years of running apache-php-postgres with no issues, I'm suddenly
receiving the cannot connect to postgres - too many clients already
error on my script pages.

1. Does everyone ALWAYS have Apache max connections lower than postgres
max clients? I tried this but the problem still returned.

2.I'm using pg_pconnect().

3. Traffic is slightly higher lately but not that high.

4. I'm thinking about apache changing apache maxrequestsperchild from 0
to maybe 10 or something to periodically kill apache children, but I
can't see why the maxclients in apache would overload postgres if they
are both the same number. It is hard fro me to believe there are
actually that many simultaneous users of this system, so for some
reason the connections are remaining open and unused.

Any wisdom out there?

Matt

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Mitch Pirtle 2004-12-29 16:38:22 Re: too many clients
Previous Message Adam Witney 2004-11-26 15:10:16 Inserting greek letters