Re: request for new parameter for disable promote (slave only mode)

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: request for new parameter for disable promote (slave only mode)
Дата
Msg-id CA+TgmobfQSGCYhqGUQu20QtmXAJES=611qG8JU0onZtSBvfmeA@mail.gmail.com
обсуждение исходный текст
Ответ на request for new parameter for disable promote (slave only mode)  (Ioseph Kim <pgsql-kr@postgresql.kr>)
Список pgsql-hackers
On Fri, Jul 27, 2018 at 12:05 PM, Ioseph Kim <pgsql-kr@postgresql.kr> wrote:
> I want to build one master & multi slave environments to use physical replication.
> Slave nodes have low hardware spec, so I changed max_connection server parameters, and try start slave node.
> But I could not start slave nodes,
> because CheckRequiredParameterValues function (in src/backend/access/transam/xlog.c) reject to set less values then
master’svalues. 
>
> It is maybe,
> This concept is base on some slave node can be promte master.

No, it's because the machinery that computes MVCC snapshots on slaves
relies on max_connections being set high enough.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Parallel Append implementation
Следующее
От: Alexander Kuzmenkov
Дата:
Сообщение: Re: [HACKERS] PoC: full merge join on comparison clause