Troubleshoot a PostgreSQL AWS DMS task with used replication slots

Postgres 12 highlight - Replication slot copy · Complete a base backup with pg_basebackup –slot using a permanent slot · Create one or more

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 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

postgresql replication slot A physical replication slot prevents a source DB instance from removing WAL data before it's consumed by all read replicas Each read replica has its own