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