Re: Using replication to upgrade db from 12 to 16
| От | Frank Komsic |
|---|---|
| Тема | Re: Using replication to upgrade db from 12 to 16 |
| Дата | |
| Msg-id | BL3PR05MB9236C3B7229A4C96734DAB61B3AE2@BL3PR05MB9236.namprd05.prod.outlook.com обсуждение исходный текст |
| Ответ на | Re: Using replication to upgrade db from 12 to 16 (Kashif Zeeshan <kashi.zeeshan@gmail.com>) |
| Ответы |
Re: Using replication to upgrade db from 12 to 16
|
| Список | pgsql-sql |
Hi Zashif,
I read somewhere that it was possible to have a replication on an Upgraded major version I believe by using logical replication?
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 по дате отправления: