Re: Too many clients to Postgresql server

On Thu, 18 Jul 2002, Thomas Beutin wrote:

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

This isn't true, the max_persistant connections in the php.ini sets the
max number of persistant connections per apache/php backend. I.e. setting
max persistant to 16 would limit each apache child to 16 persistant
connections. If apache has the default of 150 children set, that's 150*16
max persistant connections.

The best bet here if one HAS to use persistant connections is to limit the
apache server to some smaller number (max_psql_connections-4 or
somethning)

Scott Marlowe

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