Re: Postgres PHP error

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: rahul143 <rk204885(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres PHP error
Date: 2012-12-04 03:46:01
Message-ID: CAB7nPqS6Yo+EStmULeYhHWLLP+04oUpNKAGsbHUTOeNzhRBz+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Dec 3, 2012 at 2:18 PM, rahul143 <rk204885(at)gmail(dot)com> wrote:

> Hi All
>
> 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?
>
This error means that the maximum number of clients that can connect at the
same time has been reached on server.

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

Increase your maximum number of users.
Then, you can still improve your application by reducing the time they hold
connections on server.
--
Michael Paquier
http://michael.otacoo.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2012-12-04 09:30:31 RE: [GENERAL] Strange Connection Problem….
Previous Message Alvaro Herrera 2012-12-03 20:27:06 Re: Postgres PHP error