Postgres Pro
Downloads
Home   >   mailing lists

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

From Achilleas Mantzios
Subject Re: Using replication to upgrade db from 12 to 16
Date
Msg-id 1e354854-9095-4de5-ab5b-8443ed581818@cloud.gatewaynet.com
Whole thread Raw
In response to Using replication to upgrade db from 12 to 16  (Frank Komsic <komsicf@shoeicanada.com>)
List pgsql-sql
Tree view
Στις 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)

pgsql-sql by date:

Previous
From: Kashif Zeeshan
Date:
Subject: Re: Using replication to upgrade db from 12 to 16
Next
From: Frank Komsic
Date:
Subject: Powerfailure caused a reduction in INSERT performance of version 12 database.