Re: "too many clients" and no cure - Mailing list pgsql-admin

From Tom Lane
Subject Re: "too many clients" and no cure
Date
Msg-id 13531.1101922883@sss.pgh.pa.us
Whole thread Raw
In response to Re: "too many clients" and no cure  (postgresql@thomasbache.de)
List pgsql-admin
postgresql@thomasbache.de writes:
>> It sounds like you forgot to restart the postmaster after changing
>> postgresql.conf.  This is one of the parameters that is frozen at
>> server start ...

> No, I did restart the postmaster. Actually more than once.

In that case, maybe you edited the wrong copy of postgresql.conf?
Try checking "SHOW max_connections" to verify what the postmaster
thinks the value is.

> I do not have to restart the server after changing kernel parameters
> with sysctl, do I?

I don't think kernel limits would lead to "too many clients" --- you'd
be getting different sorts of failures if the problem were in that area.

            regards, tom lane

pgsql-admin by date:

Previous
From: Deepak Vohra
Date:
Subject: Please remove from subscription
Next
From: "Vishal Kashyap @ [SaiHertz]"
Date:
Subject: Re: Please remove from subscription