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

От

Magnus Rolf

Тема

Дата

29 декабря 2021 г. в 16:00:24

Msg-id

DBBPR03MB67960655151BF9CA2833E88FE6449@DBBPR03MB6796.eurprd03.prod.outlook.com

обсуждение

Ответ на

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

Список

pgsql-admin

Дерево обсуждения

PostgreSQL Replication between Different Major Version (11-13) Ram Pratap Maurya <ram.maurya@lavainternational.in> 29 декабря 2021 г. в 12:30:57

Re: PostgreSQL Replication between Different Major Version (11-13) Scott Ribe <scott_ribe@elevated-dev.com> 29 декабря 2021 г. в 17:00:06

RE: PostgreSQL Replication between Different Major Version (11-13) Alvaro Aguayo <aaguayo@opensysperu.com> 29 декабря 2021 г. в 12:47:01

Re: PostgreSQL Replication between Different Major Version (11-13) Magnus Hagander <magnus@hagander.net> 29 декабря 2021 г. в 13:27:36

Re: PostgreSQL Replication between Different Major Version (11-13) Magnus Rolf <magnus.rolf@outlook.com> 29 декабря 2021 г. в 16:00:24

Re: PostgreSQL Replication between Different Major Version (11-13) Adarsh Sharma <eddy.adarsh@gmail.com> 29 декабря 2021 г. в 12:58:58

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

Outlook voor Android downloaden

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

В списке pgsql-admin по дате отправления

Предыдущее

От: Joseph Hammerman

Дата: 29 декабря 2021 г. в 15:16:44

Сообщение: Triaging pg_ctl shutdown hang

Следующее

От: Scott Ribe

Дата: 29 декабря 2021 г. в 17:00:06

Сообщение: Re: PostgreSQL Replication between Different Major Version (11-13)