Re: "too many clients" and no cure

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: "too many clients" and no cure
Дата
Msg-id 13531.1101922883@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: "too many clients" and no cure  (postgresql@thomasbache.de)
Список 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 по дате отправления:

Предыдущее
От: Deepak Vohra
Дата:
Сообщение: Please remove from subscription
Следующее
От: "Vishal Kashyap @ [SaiHertz]"
Дата:
Сообщение: Re: Please remove from subscription