Postgres Logical Replication and Idle Databases

When dropping a subscription, the replication slot should be kept This In that case, disassociate the slot from the subscription using ALTER SUBSCRIPTION

Replication Slot · feature introduced in PostgresQL along with logical decoding · is a feature that ensures that the master server will retain

postgres create logical 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 The slot state state=present implies the slot must be present in the system state=absent implies the groups must be revoked from target_roles