Postgres Pro
Downloads
Home   >   mailing lists

Re: Using replication to upgrade db from 12 to 16 - Mailing list pgsql-sql

From Frank Komsic
Subject Re: Using replication to upgrade db from 12 to 16
Date
Msg-id BL3PR05MB9236C3B7229A4C96734DAB61B3AE2@BL3PR05MB9236.namprd05.prod.outlook.com
Whole thread Raw
In response to Re: Using replication to upgrade db from 12 to 16  (Kashif Zeeshan <kashi.zeeshan@gmail.com>)
Responses Re: Using replication to upgrade db from 12 to 16
List pgsql-sql
Tree view

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 by date:

Previous
From: Kashif Zeeshan
Date:
Subject: Re: Using replication to upgrade db from 12 to 16
Next
From: Kashif Zeeshan
Date:
Subject: Re: Using replication to upgrade db from 12 to 16