Logical replication slots

Logical replication slots postgres delete replication slot You must drop the logical replication slot in the primary server if the corresponding subscriber no longer exists Otherwise, the WAL files postgres delete replication slot NOTICE: created replication slot my_subscription on publisher CREATE SUBSCRIPTION From now on, all INSERT , UPDATE , and DELETE

postgres delete replication slot 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

postgres create replication slot Use pg_drop_replication_slot : select pg_drop_replication_slot; See the docs and this blog The replication slot must be Fixing PostgreSQL database replication errors · Removing an inactive replication slot · Message: WARNING: oldest xmin is far in the past and pg_wal size growing