From: | Shane Ambler <pgsql(at)007Marketing(dot)com> |
---|---|
To: | Martin Kuria <martinkuria(at)hotmail(dot)com>, PostgreSQL Mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Unable to connect to PostgreSQL server |
Date: | 2006-04-20 09:32:26 |
Message-ID: | C06D8B42.3F720%pgsql@007Marketing.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Look in data/postgres.conf
You will find a line there such as max_connections = 50 you will also need
to check that shared_buffers is at least twice the max_connections.
You can also start Postmaster with -B nBuffers -N maxbackends
On 20/4/2006 17:41, "Martin Kuria" <martinkuria(at)hotmail(dot)com> wrote:
> hi,
>
> I have a problem with my postgresql database it always gives me an error:
>
> Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL
> server: FATAL: sorry, too many clients already in ~/includes/DbConnector.php
> on line 27
>
> Please advice how I can manage my database to handle enough connections
> please advice.
>
> +-----------------------------------------------------+
> | Martin W. Kuria (Mr.) martin(dot)kuria(at)unon(dot)org
> +----------------------------------------------------+
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today it's FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
From | Date | Subject | |
---|---|---|---|
Next Message | news.postgresql.org | 2006-04-20 09:39:03 | Notification EXTRA data |
Previous Message | dsids | 2006-04-20 09:06:55 | Re: tomcat postgresql connectivity error |