Re: Unable to connect to PostgreSQL server

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
>

In response to

Browse pgsql-general by date

  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