Re: Unable to connect to PostgreSQL server

You may also want to look into your php.ini settings.

pgsql.max_persistent pgsql.max_links pgsql.auto_reset_persistent and
PGSQL_CONNECT_FORCE_NEW are options you would want to check into.

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