From: Alvaro Aguayo <aaguayo@opensysperu.com>
To: Ram Pratap Maurya <ram.maurya@lavainternational.in>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Cc: Ashish Chugh <ashish.chugh@lavainternational.in>
Subject: RE: PostgreSQL Replication between Different Major Version (11-13)
Date: Wed, 29 Dec 2021 12:47:01 +0000
Message-ID: <SC1P15201MB223863798D1E8B1529034091AF449@SC1P15201MB2238.LAMP152.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <KL1PR0601MB443387CD96233DD27D005009F0449@KL1PR0601MB4433.apcprd06.prod.outlook.com>
References: <KL1PR0601MB443387CD96233DD27D005009F0449@KL1PR0601MB4433.apcprd06.prod.outlook.com>
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@ocs.pe
From: Ram Pratap Maurya <ram.maurya@lavainternational.in>
Sent: 29 December 2021 07:31
To: pgsql-admin@lists.postgresql.org
Cc: Ashish Chugh <ashish.chugh@lavainternational.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: aaguayo@opensysperu.com, ram.maurya@lavainternational.in, pgsql-admin@lists.postgresql.org, ashish.chugh@lavainternational.in
Subject: RE: PostgreSQL Replication between Different Major Version (11-13)
In-Reply-To: <SC1P15201MB223863798D1E8B1529034091AF449@SC1P15201MB2238.LAMP152.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox