Too many clients to Postgresql server - Mailing list pgsql-general

From Siva Kumar
Subject Too many clients to Postgresql server
Date
Msg-id 200207181909.01279.siva@leatherlink.net
Whole thread Raw
Responses Re: Too many clients to Postgresql server
List pgsql-general
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,


Siva Kumar





--
Ma Siva Kumar,
BSG LeatherLink,
Chennai, India.
Phone: 6215110
Email: siva@leatherlink.net
URL: http://www.leatherlink.net/

pgsql-general by date:

Previous
From: Holger Klawitter
Date:
Subject: Re: SQL If-Then Logic in Query
Next
From: Tom Lane
Date:
Subject: Re: OIDs (Or: another RTFM question?)