Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1sVE99-008h5B-S0
	for pgsql-sql@arkaria.postgresql.org; Sat, 20 Jul 2024 17:45:27 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1sVE97-000h0R-SZ
	for pgsql-sql@arkaria.postgresql.org; Sat, 20 Jul 2024 17:45:26 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <kashi.zeeshan@gmail.com>)
	id 1sVE97-000h0J-HE
	for pgsql-sql@lists.postgresql.org; Sat, 20 Jul 2024 17:45:26 +0000
Received: from mail-vs1-xe36.google.com ([2607:f8b0:4864:20::e36])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <kashi.zeeshan@gmail.com>)
	id 1sVE95-000aMy-El
	for pgsql-sql@lists.postgresql.org; Sat, 20 Jul 2024 17:45:25 +0000
Received: by mail-vs1-xe36.google.com with SMTP id
 ada2fe7eead31-48ff6336bbbso928613137.0
        for <pgsql-sql@lists.postgresql.org>;
 Sat, 20 Jul 2024 10:45:23 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1721497521; x=1722102321;
 darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=G8g3/UfHUOSDTSFjJIBkddG9UxR4R0PToBrpkwxauWo=;
        b=KTjHu1e7NhWZOs3I38S1/Mfjs0C9wBmUhMWQWrLbLND25xDOIq8wtV4JKSNb/46zre
         Qnm2evIPanHhYRQJTMyObXwV7+8cqeod56J0FLR7nljhJE9phzrmHGCutrO0f0yAmYa3
         C8jpw6ARBGPOQ7wqIJwKgz83v7VUogCzitOCVCAXvRj9hlk3lJkDvlXmgyFXf+3MNsWy
         U+iFM3zf/fdk9XfCP/Lh88IaZFxJEyGJ0ssxFaHj/ITk+HIktWuzE6VDdVC++cXt+aNQ
         NVlTjt5p6nj7FDOv6fbJJsFdko/jutNWUH2aDYvCDSDT0lt0uPLelM67lHel6dm7ySRy
         DJxA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1721497521; x=1722102321;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=G8g3/UfHUOSDTSFjJIBkddG9UxR4R0PToBrpkwxauWo=;
        b=EsfWzyR3fVeCJKOkE0tXk121XAVK6Lv/evb/a8MOcx7Q1RHIEi6GoGyshsEEv6YfWQ
         sQHcis4emGB7fenzwKqZuWsIXZ7YVLlshgcuJ0nKZOAoPPJm0VMx3W1riOyN8uggYzfn
         0mQN7zgYPJAUda4hC/iEoQrfUusBE4Y0Sg/ocB+uX4V9957M3j+REEHXhlxnqQvFeOCp
         BjA5vyL9NJksueMEpQTLcPVgdt8AXmPR3iYU/rqkC5UskAe/2H0APapzrMVle/+PEy3D
         Pa0v+QYOU0CBg3MMEs3ey9p4iR/nt6YkeGUtpkvuhRFiLFj3GoZszJ/nulO5k8yqLV8b
         +x0Q==
X-Gm-Message-State: AOJu0YzURykvhiho37KPeyaU9YElTs9rg8zq8PVY20ESagGJ0I9NcH2h
	BnsxItmg/+H6uSa/ilXKwylK3BgWYms0Gbqb+c+RcdgUZlKMilxMjBoL1DY277GNoa5d9D8BWsR
	6WE6qbVFzCJXaGSvbwBW7438BcPh5qg==
X-Google-Smtp-Source: 
 AGHT+IEQH+RZypfIkwpcEYfSCpvQZcfAu8Xf7/zW1rHWxWyM/eHWxAzP1qFD3T4Djcx7S6hIuGIrcWN1fpqeGEuAi80=
X-Received: by 2002:a05:6102:4a95:b0:48f:4580:fb0c with SMTP id
 ada2fe7eead31-49283f33955mr4537938137.24.1721497521178; Sat, 20 Jul 2024
 10:45:21 -0700 (PDT)
MIME-Version: 1.0
References: 
 <BL3PR05MB9236BC5C51ED0E7B151C1FCCB3AE2@BL3PR05MB9236.namprd05.prod.outlook.com>
In-Reply-To: 
 <BL3PR05MB9236BC5C51ED0E7B151C1FCCB3AE2@BL3PR05MB9236.namprd05.prod.outlook.com>
From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Date: Sat, 20 Jul 2024 22:45:09 +0500
Message-ID: 
 <CAAPsdhfWrOTP9TcPhp4TJUDK2oMEO-=pNBHXo9zj2_TuLDw2dw@mail.gmail.com>
Subject: Re: Using replication to upgrade db from 12 to 16
To: Frank Komsic <komsicf@shoeicanada.com>
Cc: "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003b4fb3061db160fe"
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/CAAPsdhfWrOTP9TcPhp4TJUDK2oMEO-%3DpNBHXo9zj2_TuLDw2dw%40mail.gmail.com>
Precedence: bulk

--0000000000003b4fb3061db160fe
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFPM 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 liv=
e
> data?
>
>
>
> Thanks
>
>
> Frank
>

--0000000000003b4fb3061db160fe
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi Frank</div><div><br></div><div>Streaming/Physical =
Replication requires that both Master and Standby are using the same OS and=
 same PG major version.</div><div><br></div><div>Thanks</div><div>Kashif Ze=
eshan<br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=
=3D"gmail_attr">On Sat, Jul 20, 2024 at 10:01=E2=80=AFPM Frank Komsic &lt;<=
a href=3D"mailto:komsicf@shoeicanada.com">komsicf@shoeicanada.com</a>&gt; w=
rote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0p=
x 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class=
=3D"msg1814652727414295906">





<div style=3D"overflow-wrap: break-word;" lang=3D"EN-CA">
<div class=3D"m_1814652727414295906WordSection1">
<p class=3D"MsoNormal">Hi,<u></u><u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></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?<u></u><u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal">Thanks<u></u><u></u></p>
<p class=3D"MsoNormal"><br>
Frank<u></u><u></u></p>
</div>
</div>

</div></blockquote></div>

--0000000000003b4fb3061db160fe--