Troubleshoot a PostgreSQL AWS DMS task with used replication slots

Troubleshoot a PostgreSQL AWS DMS task with used replication slots postgresql drop 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 postgresql drop replication slot Specifies the maximum number of replication slots that the server can support The default is 10

postgresql drop replication slot Now a common cause for this kind of issue are replication slots which are not advanced: in that case, Postgres will hold on to all WAL segments

postgresql create replication slot Specify that this replication slot is a temporary one Temporary slots are not saved to disk and are automatically dropped on error or when the session has Replication slots are marked as 'inactive' when the replication client connected to the slot disconnects Inactive replication slots cause WAL files to be