Inside logical replication in PostgreSQL: How it works

When dropping a subscription, the replication slot should be kept This could be useful when the subscriber database is being moved to a different host and will

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

dropz slot demo Drop the replication slot created on the incorrect database An unused slot will continue to hold on to the Write Ahead Log forever which can cause server bloat

drop em slot demo Optional parameter that when yes specifies that the LSN for this replication slot be reserved immediately, otherwise the default, no , specifies that the LSN is