Troubleshoot a PostgreSQL AWS DMS task with used replication slots

website create replication slot created replication slot my_sub on publisher CREATE SUBSCRIPTION Now, verify the existing row has been replicated: postgres=# create logical replication slot postgres Setup using CDC​ · Provide additional REPLICATION permissions to read-only user · Enable logical replication on your Postgres database · Create a replication slot

create replication slot Used replication slots continue to occupy space If you run multiple AWS DMS tasks or you have old tasks that run on the same DB instance, then remove the used  In a logical replication setup, these slots are used to manage and control the flow of changes from the source database to  name - The name of the replication slot · plugin - Sets the output plugin · database

Share

Share

Link

Turn off sharing Copy link

See all details