Postgres Pro
Downloads
Home   >   mailing lists

Thread: Using replication to upgrade db from 12 to 16

Using replication to upgrade db from 12 to 16

From
Frank Komsic
Date:

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

Re: Using replication to upgrade db from 12 to 16

From
Kashif Zeeshan
Date:
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

Re: Using replication to upgrade db from 12 to 16

From
Frank Komsic
Date:

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

Re: Using replication to upgrade db from 12 to 16

From
Kashif Zeeshan
Date:
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

Re: Using replication to upgrade db from 12 to 16

From
Achilleas Mantzios
Date:
Στις 20/7/24 20:01, ο/η Frank Komsic έγραψε:
@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:Aptos; panose-1:2 11 0 4 2 2 2 2 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; font-size:11.0pt; font-family:"Aptos",sans-serif; mso-ligatures:standardcontextual;}span.EmailStyle17 {mso-style-type:personal-compose; font-family:"Aptos",sans-serif; color:windowtext;}.MsoChpDefault {mso-style-type:export-only; font-size:11.0pt;}div.WordSection1 {page:WordSection1;}

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?

absolutely

 

Thanks


Frank

-- 
Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt (as agents only)