0

I have a production PostgreSQL database that replicate from publisher to subscriber using pglogical extension. My database is running on postgres 11 and I want to upgrade to postgres 14. I first upgrade the subscriber and then the publisher and start both databases but the replication fail.I have some data on the subscriber database that I do not want to loss if I have to set up a fresh copy from the publisher. My question is how can I upgrade the subscriber and publisher and still keep them in sync? thanks

upgrade subscriber first and then publisher and start both databases but replication fail

asked Jun 2, 2023 at 19:54
14
  • With what error message does the replication fail? Commented Jun 2, 2023 at 23:27
  • the databases (publisher and subscribers) start up as separate databases. I check the status of the subscriber and the status is down. I check the replication slot on the publisher is was no longer available Commented Jun 6, 2023 at 13:27
  • Look in the replica log file. It should have more to say than just "it is down". Commented Jun 6, 2023 at 23:56
  • 2023年06月07日 08:47:53 EDT,5/0,0,LOG,00000,"starting apply for subscription test_04",,,,,,,,,"pglogical apply 16404:3815206147","pglogical apply 16404:3815206147",,0 Commented Jun 7, 2023 at 12:53
  • ERROR,42704,"replication origin ""pgl_ateb_db_01_test_04"" does not exist",,,,,,,,,"pglogical apply 16404:3815206147","pglogical apply 16404:3815206147",,0 Commented Jun 7, 2023 at 12:54

0

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.