Logical Replication in PostgreSQL

Logical Replication in PostgreSQL postgres drop replication slot Usage · DROP SUBSCRIPTION cannot be executed in a transaction · execution will fail if the replication slot cannot be dropped, because the publisher is postgres drop replication slot Use pg_drop_replication_slot : select pg_drop_replication_slot; See the docs and this blog The replication slot must be

postgres drop replication slot When replication slots is enabled, you might end up running out of disk space due to PostgreSQL trying to retain WAL files requested by a replication slot

postgresql drop replication slot If a logical replication slot is no longer used, drop it immediately The 'active' column in the pg_replication_slots view will indicate whether The replication slot basically tells Postgres not to recycle or remove any WAL files that could ultimately prevent it from catching up with