Re: preventing the effective fork bomb when restarting a high traffic server?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: preventing the effective fork bomb when restarting a high traffic server?
Дата
Msg-id 28598.1102976289@sss.pgh.pa.us
обсуждение исходный текст
Ответ на preventing the effective fork bomb when restarting a high traffic server?  (Jeff <threshar@torgo.978.org>)
Список pgsql-admin
Jeff <threshar@torgo.978.org> writes:
> The problem I'm encountering is when I restart PG for whatever reason
> it takes it a long time to come back fully online: the reason:  the
> machine is dealing with over 100 connection attempts / second while
> trying to replay the logical logs.

Um, perhaps you should allow the database to shut down normally, instead
of kill -9 or whatever you're using?  There should not be any log
replay needed after an ordinary restart.

In any case, I think the best solution would be to fix your frontends to
wait a little bit between connection attempts...

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: plperl loading
Следующее
От: Tom Lane
Дата:
Сообщение: Re: From latin9 to sql_ascii??