RE: PostgreSQL Replication between Different Major Version (11-13)

Hi.

Not with PostgreSQL itself, but you can achieve that with pglogical: https://www.2ndquadrant.com/en/resources-old/pglogical/

It supports replication across different versions. One of its intended usages is version migration with minimal (almost zero) downtime.

But please note that it won’t create a read only replica: The replica will always be writable. You should look for some way to restrict writing, via triggers or permissions, if you really want the replica to be read only.

Regards,

Alvaro Aguayo
Operations Manager
Jr. Prolongación Ayacucho 177 Urb. Santa Eulalia - San Miguel
Telf. (+51-1) 680-5726
E-mail: aaguayo(at)ocs(dot)pe

From: Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in>
Sent: 29 December 2021 07:31
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Cc: Ashish Chugh <ashish(dot)chugh(at)lavainternational(dot)in>
Subject: PostgreSQL Replication between Different Major Version (11-13)

Hi Support,

We would like to perform PostgreSQL Replication between Different Major Version to avoid database upgrade. Scenario is as follows.

1. PostgreSQL Replication from PostgreSQL Version 11 To PostgreSQL Version 13.
2. Want to Setup Production Read Only Replication from Primary (11 Version) To Secondary (13 Version)

We want to perform above activity to avoid Database Upgrade. Please let us know if this is possible to setup Replication between Different Major Version (11-13).

Regards,
Ram Pratap.