Re: Postgres PHP error - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Postgres PHP error
Date
Msg-id D960CB61B694CF459DCFB4B0128514C208C99F4A@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Postgres PHP error  (rahul143 <rk204885@gmail.com>)
List pgsql-general
rahul143 wrote:
> Im receiving the following error, on a php page, conneting to postgres
7.4,
> installed on Mandrake 10.0
> <snip>
> Error Description: pg_connect(): Unable to connect to PostgreSQL
server:
> FATAL: sorry, too many clients already .
> </snip>
> Can anyone tell me what this means?
> Is there a performance setting I need to set under the postgresql conf
file.
> I have checked, and its set to 100 users.
> This error strangely has only happened once. Last week Monday.

The parameter is max_connections, and it seems that last week Monday
you had exhausted that limit.  You should try to figure out what caused
the problem rather than indiscriminately raising max_connections.

You could turn on log_connections, that would help finding the cause.

I guess I don't have to tell you that you should upgrade.

Yours,
Laurenz Albe


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: execute if statement
Next
From: "Albe Laurenz"
Date:
Subject: Re: guids / bytea and index use ?