Add or remove replication slots from a PostgreSQL database

Add or remove replication slots from a PostgreSQL database postgres delete replication slot Use pg_drop_replication_slot : select pg_drop_replication_slot; See the docs and this blog The replication slot must be postgres delete replication slot Logical decoding and replication slots being introduced in PostgreSQL Soft delete

postgres delete replication slot src=# DELETE FROM nopk WHERE foo='boston'; ERROR: cannot delete from table nopk because it does not have a replica identity and publishes

postgresql replication slot If set to -1 , you will not be able to delete WAL files due to open logical replication slots that information is not read from  Logical decoding and replication slots being introduced in PostgreSQL Soft delete