Обсуждение: State which instances must have "wal_level=logical" in LogicalReplication in Postgres 10

Поиск
Список
Период
Сортировка

State which instances must have "wal_level=logical" in LogicalReplication in Postgres 10

От
contact@gurpartap.com
Дата:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/static/logical-replication-quick-setup.html
Description:

Hello!

In a logical replication setup, this guide needs to explicitly help the user
identify the postgresql instances that must have "wal_level = logical"
defined.

According to someone on IRC, it must only be set for the publisher (while
the subscribers are at default wal_level value – i.e. commented out in
postgresql.conf). I tested and it seems to work as expected.

So the documentation should suggest that it must only be set on instances
are act as "publishers", (along with instances that are both publishers and
subscribers).

Best ,
Gurpartap Singh

Re: State which instances must have "wal_level=logical" in LogicalReplication in Postgres 10

От
Peter Eisentraut
Дата:
On 12/16/17 08:40, contact@gurpartap.com wrote:
> Page: https://www.postgresql.org/docs/10/static/logical-replication-quick-setup.html
> Description:
> 
> Hello!
> 
> In a logical replication setup, this guide needs to explicitly help the user
> identify the postgresql instances that must have "wal_level = logical"
> defined.

That is explained in the section before the one you are looking at.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services