Re: Using replication to upgrade db from 12 to 16

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(dot)zeeshan(at)gmail(dot)com>
Date: Saturday, July 20, 2024 at 1:45 PM
To: Frank Komsic <komsicf(at)shoeicanada(dot)com>
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org <pgsql-sql(at)lists(dot)postgresql(dot)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(at)shoeicanada(dot)com<mailto:komsicf(at)shoeicanada(dot)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