A Guide to Logical Replication and CDC in PostgreSQL

A Guide to Logical Replication and CDC in PostgreSQL replication slot does not exist Hi, I set up logical replication a few days ago, but it's throwing some weird log lines that have me worried Does anybody have experience replication slot does not exist The table on db-replica does not need to be identical to its db-master counterpart NOTICE: created replication slot my_subscription

replication slot does not exist A PostgreSQL replication slot may be stuck due to one of the following reasons: Check if the bgwriter process is healthy by inspecting its

replication slot You must drop unused replication slots Failing to do so can lead to server unavailability How to drop a slot If you are not actively replication slot geo_secondary_my_domain_com does not exist? This occurs when PostgreSQL does not have a replication slot for the secondary node by that name