Logical replication halted due to this slot has been invalidated

Logical replication halted due to this slot has been invalidated drop replication slot postgres The concept of replication slots was introduced in PostgreSQL and was created to prevent a primary instance to delete WAL that a replica drops of gold slot 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

drops of gold slot pg_drop_replication_slot() is a system function for removing a physical or logical replication slot pg_drop_replication_slot() was added in PostgreSQL

drop replication slot postgres Usage · DROP SUBSCRIPTION cannot be executed in a transaction · execution will fail if the replication slot cannot be dropped, because the publisher is By themselves, replication slots occupy very little disk space They just store tiny bit of metadata, including a pointer to a position in WAL