| From: | Adarsh Sharma <eddy(dot)adarsh(at)gmail(dot)com> |
|---|---|
| To: | Alvaro Aguayo <aaguayo(at)opensysperu(dot)com> |
| Cc: | Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>, Ashish Chugh <ashish(dot)chugh(at)lavainternational(dot)in> |
| Subject: | Re: PostgreSQL Replication between Different Major Version (11-13) |
| Date: | 2021-12-29 12:58:58 |
| Message-ID: | CAGx-QqLyVHBaFn4WUqcJ=UwuY6VJDUdhWP=g8HABm-b3GmHihQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)opensysperu(dot)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(at)ocs(dot)pe
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2021-12-29 13:27:36 | Re: PostgreSQL Replication between Different Major Version (11-13) |
| Previous Message | Alvaro Aguayo | 2021-12-29 12:47:01 | RE: PostgreSQL Replication between Different Major Version (11-13) |