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

From: Magnus Hagander <magnus(at)hagander(dot)net>
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 13:27:36
Message-ID: CABUevEx91uiXpXtRG8-4sfsymN=WagevCdaOH16SbAGDZVxMaA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Dec 29, 2021 at 1:47 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/

Sure, you can do that with PostgreSQL itself as well, with logical
replication, as of version 10. It has the same caveats as with
pglogical, but the basic functionality is there.

You cannot do it with *physical* replication, that's still true.

--
Magnus Hagander
Me: https://www.hagander.net/
Work: https://www.redpill-linpro.com/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joseph Hammerman 2021-12-29 15:16:44 Triaging pg_ctl shutdown hang
Previous Message Adarsh Sharma 2021-12-29 12:58:58 Re: PostgreSQL Replication between Different Major Version (11-13)