PostgreSQL 10 Administration Cookbook - Fourth Edition

Getting ready

To use pglogical, the publisher and subscriber must be running PostgreSQL 9.4 or higher and you must install the pglogical extension on both nodes. 

The procedure is the following:

1. Identify all the nodes that will work together as parts of your replication architecture.
2. Each LSR link can replicate changes from a single database. If you have multiple databases in your PostgreSQL server, you will need one LSR link per database (not counting template0 and template1).
3. Each LSR link will use one connection and one slot. Set the max_replication_slots and max_connections parameters to match those requirements.

 

4. Each LSR link requires one WAL sender on the publisher. Set max_wal_senders to match this requirement.
5. Each LSR link requires ...