PostgreSQL Logical Replication Gotchas

PostgreSQL Logical Replication Gotchas postgres create replication slot Setup using CDC​ · Provide additional REPLICATION permissions to read-only user · Enable logical replication on your Postgres database · Create a replication slot postgres drop replication slot Allow you to replicate data out of Postgres · Use the write-ahead log as the source of changes · Use logical replication slots to send out

postgres drop replication slot To turn on logical replication for a newly created RDS for PostgreSQL DB instance

postgresql create replication slot Resolution · Turn on logical replication · Connect to source database in source DB instance · Create a publication for source tables · Connect to target database Create an instance with storage attributes for replication slots and schedule the first synchronisation Parameters: postgresql