Re: Using replication to upgrade db from 12 to 16

Поиск
Список
Период
Сортировка
От Kashif Zeeshan
Тема Re: Using replication to upgrade db from 12 to 16
Дата
Msg-id CAAPsdhfKPPk-RQEvJsGNX4M1v6OyEwZH=RGv96Lwe65AnKw5aQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Using replication to upgrade db from 12 to 16  (Frank Komsic <komsicf@shoeicanada.com>)
Список pgsql-sql
Дерево обсуждения
Hi Frank

On Sat, Jul 20, 2024 at 11:00 PM Frank Komsic <komsicf@shoeicanada.com> wrote:

Hi Zashif,

 

I read somewhere that it was possible to have a replication on an Upgraded major version I believe by using logical replication?

The restrictions I mentioned are with Physical Replication.
You can use Logical Replication which doesn't have these restrictions but it has some of its own e.g.
1. It supports replication of Tables only
2. It support only DML Commands (INSERT, UPDATE, DELETE) and TRUNCATE (with some restrictions)

You can check the restrictions on following link



Regards
Kashif Zeeshan

 

Not sure myself, but was hoping there is a way as our application required some debugging after the upgrade due to improper concatenation of SQL statements that was not enforced in PGSQL-12.

 

Thanks

Frank

 

From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Date: Saturday, July 20, 2024 at 1:45 PM
To: Frank Komsic <komsicf@shoeicanada.com>
Cc: pgsql-sql@lists.postgresql.org <pgsql-sql@lists.postgresql.org>
Subject: Re: Using replication to upgrade db from 12 to 16

Hi Frank

 

Streaming/Physical Replication requires that both Master and Standby are using the same OS and same PG major version.

 

Thanks

Kashif Zeeshan

 

On Sat, Jul 20, 2024 at 10:01 PM Frank Komsic <komsicf@shoeicanada.com> wrote:

Hi,

 

Is it possible to maintain our MASTER db in Pgsql-12 and a replica database in Pgsql-16 as SLAVE for application testing with the latest live data?

 

Thanks


Frank

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