From: | Siva Kumar <siva(at)leatherlink(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Too many clients to Postgresql server |
Date: | 2002-07-19 09:52:48 |
Message-ID: | 200207190952.48999.siva@leatherlink.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for the advice.
I went through the configuraiton files at the server (the service provider is
not of much help) and found the following:
MaxClients in httpd.conf = 2048
MaxRequestsPerChild in httpd.conf = 0
pgsql.allow.persistent in php.ini =On
pgsql.max_persistent = -1 (Unlimited)
pgsql.max_links = -1 (Unlimited)
The support person at the provider told me that they are just using the
default file for postgresql.conf (version 7.2.1). I could not read the file
as the read access to the file is denied.
When I faced the "maximum clients reached" message yesterday, I checked the
number of postmaster processes running, it was 32 connections made by my user
name. This morning this has come down to 8. Therefore I guess, the maximum is
reached at 32.
Can you please suggest what is to be changed to increase the 32 connection
limit. (I am just learning as I go along with all these, so please bear with
me).
Best regards,
Siva Kumar
Ma Siva Kumar,
BSG LeatherLink,
Chennai, India.
Phone: 6215110
Email: siva(at)leatherlink(dot)net
URL: http://www.leatherlink.net/
From | Date | Subject | |
---|---|---|---|
Next Message | Janning Vygen | 2002-07-19 09:54:48 | Re: select a ranking |
Previous Message | frank_lupo | 2002-07-19 09:44:58 | problem set TIMEZONE |