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:
- Identify all the nodes that will work together as parts of your replication architecture.
- 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).
- Each LSR link will use one connection and one slot. Set the max_replication_slots and max_connections parameters to match those requirements.
- Each LSR link requires one WAL sender on the publisher. Set max_wal_senders to match this requirement.
- Each LSR link requires ...
