From: | Ericson Smith <eric(at)did-it(dot)com> |
---|---|
To: | Siva Kumar <siva(at)leatherlink(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Too many clients to Postgresql server |
Date: | 2002-07-19 13:08:33 |
Message-ID: | 1027084118.11675.20.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Your hosting provider needs to change their "postgresql.conf" and
increase the number of connections there. My system is set to:
max_connections = 512
In your case, this would still be well below the 2048 possible
connections that you could get from Apache. So its up to them to decide
how they want to proceed.
- Ericson Smith
eric(at)did-it(dot)com
On Fri, 2002-07-19 at 05:52, Siva Kumar wrote:
> 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/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-07-19 13:16:14 | Re: Can't link to libpq |
Previous Message | Tom Lane | 2002-07-19 13:07:20 | Re: OIDs (Or: another RTFM question?) |