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

Поиск
Список
Период
Сортировка
От Magnus Rolf
Тема Re: PostgreSQL Replication between Different Major Version (11-13)
Дата
Msg-id DBBPR03MB67960655151BF9CA2833E88FE6449@DBBPR03MB6796.eurprd03.prod.outlook.com
обсуждение исходный текст
Ответ на Re: PostgreSQL Replication between Different Major Version (11-13)  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Joseph Hammerman
Дата:
Сообщение: Triaging pg_ctl shutdown hang
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: PostgreSQL Replication between Different Major Version (11-13)