Postgres Pro
Downloads
Home   >   mailing lists

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

From Magnus Rolf
Subject Re: PostgreSQL Replication between Different Major Version (11-13)
Date
Msg-id DBBPR03MB67960655151BF9CA2833E88FE6449@DBBPR03MB6796.eurprd03.prod.outlook.com
Whole thread Raw
In response to Re: PostgreSQL Replication between Different Major Version (11-13)  (Magnus Hagander <magnus@hagander.net>)
List pgsql-admin
Tree view
Just use the build in logical replication of PostgreSQL. It works perfectly between PG v-11 and PG v-13.
Only requirement is each table must have a primary key to assure data object consistency and integrity.
Tables which are not updated by client tool (archive tables) might be migrated by using normal pgdump/psql or pg_restore.

Magnus Rolf

From: Magnus Hagander <magnus@hagander.net>
Sent: Wednesday, December 29, 2021 2:27:36 PM
To: Alvaro Aguayo <aaguayo@opensysperu.com>
Cc: Ram Pratap Maurya <ram.maurya@lavainternational.in>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; Ashish Chugh <ashish.chugh@lavainternational.in>
Subject: Re: PostgreSQL Replication between Different Major Version (11-13)
 
On Wed, Dec 29, 2021 at 1:47 PM Alvaro Aguayo <aaguayo@opensysperu.com> wrote:
>
> Hi.
>
>
>
> Not with PostgreSQL itself, but you can achieve that with pglogical: https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.2ndquadrant.com%2Fen%2Fresources-old%2Fpglogical%2F&amp;data=04%7C01%7C%7C96bf1d76cf834c68d2a008d9cacf0b82%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637763812856863122%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=0BLJG2KtahzHLz%2BN1OywxZfddiQuEPJkHZdl84htDOI%3D&amp;reserved=0

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://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.hagander.net%2F&amp;data=04%7C01%7C%7C96bf1d76cf834c68d2a008d9cacf0b82%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637763812856863122%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=0XTfuZVDL67iuBdow8awywhdvtSgRGC%2FhvGmopcerk0%3D&amp;reserved=0
 Work: https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.redpill-linpro.com%2F&amp;data=04%7C01%7C%7C96bf1d76cf834c68d2a008d9cacf0b82%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637763812856863122%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=mQta930fhAvHwFz3OyzvLOfJknayamNoUwPj%2FCFj6cU%3D&amp;reserved=0


pgsql-admin by date:

Previous
From: Joseph Hammerman
Date:
Subject: Triaging pg_ctl shutdown hang
Next
From: Scott Ribe
Date:
Subject: Re: PostgreSQL Replication between Different Major Version (11-13)