Upgrading Logical Replica of PostgreSQL

Posted on

Question :

I am trying to upgrade a logical replica from PostgreSQL V10 to V13. We are using pglogical for the logical replication.

Though the upgrade process of the replica can be done, however the replication will not re-start and the subscriptions status will be down after the upgrade.

Is there a way for the logical replication to survive pg_upgrade and the replication re-starts after the upgrade?

If replication origin can be used in this scenario how can I use that to prevent it because after the upgrade in the logs I see that the origin cannot be found.

LOG: starting apply for subscription sample_subscription
ERROR: replication origin "pgl_sampledb_provider_sub" does not exist
LOG:  background worker "pglogical apply 16523:89982342" (PID 10178) exited with exit code 1

Answer :

So I figured out the problem.

pg_upgrade will not migrate the pg_replication_origin data, hence I had to re-create the origins using pg_replication_origin_create and the replication was replicating again.

Leave a Reply

Your email address will not be published. Required fields are marked *