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" <[EMAIL PROTECTED]> 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.) [EMAIL PROTECTED] >> +----------------------------------------------------+ >> >> _________________________________________________________________ >> 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 >> > ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
