Re: Using replication to upgrade db from 12 to 16 - Mailing list 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