PostgreSQL Logical Replication Gotchas

PostgreSQL Logical Replication Gotchas drop replication slot postgres A limitation of the PostgreSQL implementation is that replication slots are not cluster-aware: a replication slot exists solely on the instance drop and lock slot machine If there is a switchoverfailover to promote one of the standby, the new primary won't have any idea about the replication slot maintained by

drop and lock slot machine DROP PUBLICATION removes an existing publication from the database A publication can only be dropped by its owner or a superuser Parameters IF EXISTS

drops of gold slot A PostgreSQL replication slot is a vital feature ensuring the master server retains necessary Write-Ahead Log files, even when replicas A logical replication slot can also be created on a hot standby To prevent VACUUM from removing required rows from the system catalogs, hot_standby_feedback