Use logical replication for tables in RDS for PostgreSQL

Configure logical replication using the slot⁠ ​ · Create a publication on the source cluster: CREATE PUBLICATION publication_name> FOR TABLE

Log into the master database as a superuser · Using wal2json , create a logical replication slot: · Log in as the Stitch user and verify you can read from the

create logical replication slot postgres Creating a logical replication slot Can we do better? Page 17 17 If we restart Postgres in read-only mode, existing replication slots are

create replication slot A replication slot is created on the primary database server for each standby server The slot keeps track of the last confirmed receive location of WAL data on