Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL Replication between Different Major Version (11-13) - Mailing list pgsql-admin

From Adarsh Sharma
Subject Re: PostgreSQL Replication between Different Major Version (11-13)
Date
Msg-id CAGx-QqLyVHBaFn4WUqcJ=UwuY6VJDUdhWP=g8HABm-b3GmHihQ@mail.gmail.com
Whole thread Raw
In response to RE: PostgreSQL Replication between Different Major Version (11-13)  (Alvaro Aguayo <aaguayo@opensysperu.com>)
List pgsql-admin
Tree view
Is it recommended to use pglogical for PostgreSQL 9.6 -> PostgreSQL 12 Upgrade?
I have the similar use case but wondering if there are known issues or things to watch out for before using pglogical for setting replication across different PostgreSQL version.

On Wed, Dec 29, 2021 at 6:17 PM Alvaro Aguayo <aaguayo@opensysperu.com> wrote:

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

 

pgsql-admin by date:

Previous
From: Alvaro Aguayo
Date:
Subject: RE: PostgreSQL Replication between Different Major Version (11-13)
Next
From: Magnus Hagander
Date:
Subject: Re: PostgreSQL Replication between Different Major Version (11-13)