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@xxxxxxxxxxx> 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.kuria@xxxxxxxx
+----------------------------------------------------+
_________________________________________________________________
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
