From: Frank Komsic <komsicf@shoeicanada.com>
To: "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>
Subject: Using replication to upgrade db from 12 to 16
Thread-Topic: Using replication to upgrade db from 12 to 16
Thread-Index: AQHa2sYVlk515ugwukaw4+y0o744zw==
Date: Sat, 20 Jul 2024 17:01:37 +0000
Message-ID: 
 <BL3PR05MB9236BC5C51ED0E7B151C1FCCB3AE2@BL3PR05MB9236.namprd05.prod.outlook.com>
Accept-Language: en-CA, en-US
Content-Language: en-CA
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?cy1w2ms45UmBwvqk/XxArABtDOCeHBJjKHM4km4zIT75v4boys9b51vwhrrA?=
 =?us-ascii?Q?vXvs42g3VC1ooEYWlWBB6yUzazOVv2dXStoBbTDTjqR6ICOfUAp3TNxxy4gp?=
 =?us-ascii?Q?Ttxkw1VKleOoYRJ3XOmOx2zrLSLBGjogRpCrSjd2lmdlJWPDOXVXRPIYxM4/?=
 =?us-ascii?Q?UKMpt7PKdu8N4ELK18yO5yWx586fsVy9WYp46CX2xQvleUPpTWeOCiOl10I9?=
 =?us-ascii?Q?D1gV/R0pygqFiN2Ejd0KDZtNFbZUex9goyrTIek5NDbxdCOFHBGOP4sSdo5q?=
 =?us-ascii?Q?o0lKvpPtmD3Y8BQhOgngBUgtvmKYua/jE3UBf3Jv0yyY5S4TUOtYYHtRHyf2?=
 =?us-ascii?Q?pMjI8JE89jqjoY24bkVAyA1nn8t2CLVt4Jcc3bSelCw6RjziAsRhrB10hlI4?=
 =?us-ascii?Q?jo4zLgJMRpaOcjIbwzDnkcKkAWu5j+eDW2MEbLWH2yBy1UN2H7go30sMnPGV?=
 =?us-ascii?Q?jK8x+gw1zFT+If4ixDAZ2MlS12welzaymRD8FtZyi3O3hS/qXhGJOG18Tycg?=
 =?us-ascii?Q?o5oB/1NSfW0BGuzESJdY7UmGgNbuatf9wJkw74qdwXYvBf69EJ3nyFu/7TWd?=
 =?us-ascii?Q?EatGCMEf/QnzgiibW6mkrNJYt8W7g/Yx2HugLLTKuS4wx+e9IGMp+Isj1j53?=
 =?us-ascii?Q?pCYSDhQGImB2m/GQEGiOD4HD3mwd1Peyf9QOSVK2Omt5yugkb7XAgS2o/ryE?=
 =?us-ascii?Q?VQk6tiDlSfCnxPoA9C4NPqS7yBPe+xVlYcJA+EWn/IKh3hbYE5peQQ8GYhMU?=
 =?us-ascii?Q?+Ckn3qkUtoGNZCUErr5USuZNluh8bkelLlUwyCqCDoibN49LjBCrhb9LjdcR?=
 =?us-ascii?Q?NRCpPXXqtqZWWDPTAHP2WqgLkLMvskmuWmfkm6/S4L0tAREVLCky56B9VdYC?=
 =?us-ascii?Q?B/1AIW76kKMUfCYoMfQyiJLLNLVmfHK8b0eeKRrCnD+A3140Osw9/Q779+XG?=
 =?us-ascii?Q?z+vlsIMjtNRpO/JN6CVrU4BqTtCzLQz+hud7PwFyxlKD/KcDFjNNJH4o2Vhj?=
 =?us-ascii?Q?hRV3NEbnVMDreh1G9Ii/zxILPdzylmgQrintT9pCvU2RQgBLHSCQ39ncQ8so?=
 =?us-ascii?Q?wk1EMBqtcjo9EFNMu6m6l+XXpzzUgNEp5/Vh6LHmK8eH74q6ulT0BLmZ+yUK?=
 =?us-ascii?Q?QStcLwAq0KfDfSdzPtfD522uxjUvxnisFXYDMSjQoUMViO9UJR+vN4+kKfpJ?=
 =?us-ascii?Q?f4TeUwYG5Jy25qr7eK90YY6JMvwxwrzoQ0zDse8B+/5LhTtYOWq2u4vRFxXX?=
 =?us-ascii?Q?Pu+IWOxLnTv4csC37i3pcow2XKEozM+y8KHu9/VLQeIJ9OWt3/iy0XwS/muD?=
 =?us-ascii?Q?y5OhH9bJbb3/WC8TC2VKdvY1ntnHyVFlTd4mFdc1b1wgnMZ2vQDSj+Lgl0oN?=
 =?us-ascii?Q?ln7l/vfdY6TYhWmaZbucOJbhcx02J29YwgR/BeNDB2F2bcQ8/aRMl2qlJFsg?=
 =?us-ascii?Q?O4YZOI8SK5Vbpep+FbfeHF3sozfl45s6nMmVMiFf8JXkQELwl/u0fXdsa/M1?=
 =?us-ascii?Q?YZElUnqFs+bL3hH9ycXai5w9VWGnC5EgWDi60mPTnvSXsrAvrUyNgorszSLh?=
 =?us-ascii?Q?4YaxH/x45bLQwPH9PRleiLD30c6vnIPYcbps7imd0sMJwBH6sEc8EKPngWui?=
 =?us-ascii?Q?9A=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_BL3PR05MB9236BC5C51ED0E7B151C1FCCB3AE2BL3PR05MB9236namp_"
MIME-Version: 1.0
X-OriginatorOrg: shoeicanada.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: BL3PR05MB9236.namprd05.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 372ea371-eed0-4080-f488-08dca8dd9eb1
X-MS-Exchange-CrossTenant-originalarrivaltime: 20 Jul 2024 17:01:38.2933
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 01347b42-4202-49b1-8efe-675406351eed
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 aYI1Ud2dIpuCrUv9dyk/8oGqlm9pi2JxGW0Y2nmeeyAtvmuhSBQGD3+gYdmcuRDnshmVqnAKhXGMIMfKFHJ30Q==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO1PR05MB7864
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Archived-At: 
 <https://www.postgresql.org/message-id/BL3PR05MB9236BC5C51ED0E7B151C1FCCB3AE2%40BL3PR05MB9236.namprd05.prod.outlook.com>
Precedence: bulk

--_000_BL3PR05MB9236BC5C51ED0E7B151C1FCCB3AE2BL3PR05MB9236namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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

--_000_BL3PR05MB9236BC5C51ED0E7B151C1FCCB3AE2BL3PR05MB9236namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:sc=
hemas-microsoft-com:office:word" xmlns:m=3D"http://schemas.microsoft.com/of=
fice/2004/12/omml" xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@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;}
/* Style Definitions */
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;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style>
</head>
<body lang=3D"EN-CA" link=3D"#467886" vlink=3D"#96607D" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hi,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Is it possible to maintain our MASTER db in Pgsql-12=
 and a replica database in Pgsql-16 as SLAVE for application testing with t=
he latest live data?<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Thanks<o:p></o:p></p>
<p class=3D"MsoNormal"><br>
Frank<o:p></o:p></p>
</div>
</body>
</html>

--_000_BL3PR05MB9236BC5C51ED0E7B151C1FCCB3AE2BL3PR05MB9236namp_--