Five tips on Postgres logical decoding

Logical replication is a method of replicating data objects and their changes, based upon their replication identity

For logical replication, the slot parameter _replication is set to 1 Replication slots retain the WAL files until the files are

create replication slot postgres created replication slot sub1 on publisher CREATE SUBSCRIPTION mydbops=# On node1: mydbops=# create subscription sub2 CONNECTION 'host

create replication slot Failover of the logical replication slot​ · Configure replication slot in PostgreSQL · Wait for replication slot to be ready, then begin a transaction and export