PostgreSQL Logical Replication Gotchas

PostgreSQL 12 dropped replication slot but standby is still trying to postgres delete replication slot SELECT pg_drop_replication_slot FROM pg_replication_slots WHERE slot_name IN ; The replication slots can postgres drop replication slot The concept of replication slots was introduced in PostgreSQL and was created to prevent a primary instance to delete WAL that a replica

postgres create replication slot A limitation of the PostgreSQL implementation is that replication slots are not cluster-aware: a replication slot exists solely on the instance