Re: BUG #16215: Restore failes if number of workers inpostgresql.conf is lower than on source system

Поиск
Список
Период
Сортировка
От Stefan Sonnenberg-Carstens
Тема Re: BUG #16215: Restore failes if number of workers inpostgresql.conf is lower than on source system
Дата
Msg-id CAJQkx-WhckT2zpD0WbG6uAOvo0rcoaROKX+MJiLScXcP3K997A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #16215: Restore failes if number of workers in postgresql.conf is lower than on source system  (Sergei Kornilov <sk@zsrv.org>)
Ответы Re: BUG #16215: Restore failes if number of workers in postgresql.conf is lower than on source system  (Sergei Kornilov <sk@zsrv.org>)
Список pgsql-bugs
Дерево обсуждения
Hi Sergei,

as far as I understand these restrictions apply when hot_standby is set to on AND a recovery.conf is missing.
I can confirm that hot_standby is commented out - is this setting on by default?

grep hot_standby  /etc/postgresql/10/main/postgresql.conf
#hot_standby = on                       # "off" disallows queries during recovery
#hot_standby_feedback = off             # send info from standby to prevent

Cheers

Am Fr., 17. Jan. 2020 um 08:58 Uhr schrieb Sergei Kornilov <sk@zsrv.org>:
Hello

No, this is intended and documented behavior: https://www.postgresql.org/docs/10/hot-standby.html#HOT-STANDBY-ADMIN
max_worker_processes must be at least the same as on primary. It is because exactly of our technical connection between recovery and the number of backends.

regards, Sergei


--
Stefan Sonnenberg-Carstens
IT Ingenieur

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

Предыдущее
От: Oleksandr Shulgin
Дата:
Сообщение: Re: libpq parameter parsing problem
Следующее
От: Sergei Kornilov
Дата:
Сообщение: Re: BUG #16215: Restore failes if number of workers in postgresql.conf is lower than on source system