Re: Too many clients to Postgresql server

On Thu, Jul 18, 2002 at 10:48:22AM -0400, Robert Treat wrote:
> Since you don't have the ability to bump up the maximum number of
> connections, your best bet is to switch to pg_connect. The implications
> would be that each page load will require a connection to the server,
> but unless you are doing multiple database *connections* per page, this
> impact is usually insignificant.
If You don't need the performance go to pg_connect, but You can reach the
limit this way too. You can adjust the max pg_pconnect's in the php.ini.

Greetings,
-tb

> On Thu, 2002-07-18 at 15:09, Siva Kumar wrote:
> > We have a website using postgresql and php, hosted in a shared server. The
> > settings for the maximum connections allowed is 32.
> >
> > I have used the persistent connection function pg_pconnect for all the
> > database connections. For the past one week I have started getting the
> > maximum number of clients reached message now and then. Today one of my
> > customers also called up with the same problem.
> >
> > The question is, should I change the way of connecting to the server to
> > pg_connect? What will be the implications? Otherwise, how can the persistent
> > connections be closed down?
> >
> > Thanks and best regards,
--
Thomas Beutin tb(at)laokoon(dot)IN-Berlin(dot)DE
Beam me up, Scotty. There is no intelligent live down in Redmond.