AWS DMS task fails with all of the replication slots- How to fix

Drop the replication slot with the name specified by --slot , then exit In --drop-slot mode, delete the slot with this name -t --two-phase Enables

drop replication slot postgres drop replication slot postgres

drop slot safes catalog_xmin, xid, The oldest transaction affecting the system catalogs that this slot needs the database to retain VACUUM cannot remove catalog tuples deleted

dropz slot demo Currently postgres doesn't allow dropping a replication slot that's active This can make certain operations more time-consuming or stuck in production