Troubleshooting PostgreSQL Streaming Replication Synchronization

You have to create publication before you create replication slot, otherwise you will see “publication does not exist” error The correct

does not exist dst=# Postgres complains that it needs the partition table for Jan 2019, which we have no intention of creating on the

replication slot does not exist In that case, the replica will fail unless there is a replication slot # Do not edit this file manually! # It will be overwritten by the ALTER

replication slot already exists ERROR: relation does not exist Subscriptions can only created by connecting to a master ERROR: could not create replication slot