Too many clients to Postgresql server

From: Siva Kumar <siva(at)leatherlink(dot)net>
To: PostgreSQL General Mailing List <pgsql-general(at)postgresql(dot)org>
Cc: "Focus India World Net" <office(at)focusindia(dot)com>
Subject: Too many clients to Postgresql server
Date: 2002-07-18 19:09:01
Message-ID: 200207181909.01279.siva@leatherlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)leatherlink(dot)net
URL: http://www.leatherlink.net/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Brannen 2002-07-18 19:42:32 Re: Logging SQL queries?
Previous Message Christian Lbeck 2002-07-18 17:53:51 References for PostgreSQL