Re: Unable to connect to PostgreSQL server

Martin,

please check out the server configuration documentation at

http://www.postgresql.org/docs/8.1/interactive/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS

your configuration file of choice is postgresql.conf within the data
directory.

(btw: because the default is rather big, it is very likely that there is
some "not reusing connections" or "not closing connection when ready with
usage" bug in your application)

best wishes,

Harald

On 4/20/06, 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
>

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
PostgreSQL - supported by a community that does not put you on hold