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

On Fri, Jul 27, 2018 at 12:05 PM, Ioseph Kim <pgsql-kr(at)postgresql(dot)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’s values.
>
> 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