Re: "too many clients" and no cure

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: postgresql(at)thomasbache(dot)de
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: "too many clients" and no cure
Date: 2004-12-01 17:41:23
Message-ID: 13531.1101922883@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

postgresql(at)thomasbache(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vishal Kashyap @ [SaiHertz] 2004-12-01 18:23:30 Re: Please remove from subscription
Previous Message Deepak Vohra 2004-12-01 17:24:54 Please remove from subscription