MIME-Version: 1.0
References: <CAB25yESoKwnZfVGpW6y5kg0bd-psZvCeivY2zGb7C7037fK2dg@mail.gmail.com>
In-Reply-To: <CAB25yESoKwnZfVGpW6y5kg0bd-psZvCeivY2zGb7C7037fK2dg@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 15 Apr 2026 15:16:20 -0700
Message-ID: <CAKFQuwbSNVmO=HK=QgmpP2Ngc3KhUPWTz2C_w262XiVLEiDFjg@mail.gmail.com>
Subject: Re: physical replication compatibilty
To: Jatinder Singh Sandhu <jitu.sandhu@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000eadeed064f871213"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwbSNVmO%3DHK%3DQgmpP2Ngc3KhUPWTz2C_w262XiVLEiDFjg%40mail.gmail.com>
Precedence: bulk

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

On Wed, Apr 15, 2026 at 3:06=E2=80=AFPM Jatinder Singh Sandhu <jitu.sandhu@=
gmail.com>
wrote:

> Is physical streaming replication backward compatible between these two
> major versions?
>

pg_upgrade can perform this kind of physical transfer upgrade.

Physical replication is only reliable when the source and target are
basically identical in platform and software.  It cannot be expected to
work between major versions.

David J.

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

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Wed, Apr 15, 2026 at 3:06=E2=80=AFPM Jatinder Singh San=
dhu &lt;<a href=3D"mailto:jitu.sandhu@gmail.com">jitu.sandhu@gmail.com</a>&=
gt; wrote:</span></div></div><div class=3D"gmail_quote gmail_quote_containe=
r"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div =
style=3D"font-family:&quot;Google Sans&quot;,Arial,sans-serif;font-size:16p=
x;line-height:24px;color:rgb(10,10,10)">Is physical streaming replication b=
ackward compatible between these two major versions?</div></div></blockquot=
e><div><br></div><div class=3D"gmail_default" style=3D"font-family:arial,he=
lvetica,sans-serif">pg_upgrade can perform this kind of physical transfer u=
pgrade.</div><div class=3D"gmail_default" style=3D"font-family:arial,helvet=
ica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-family=
:arial,helvetica,sans-serif">Physical replication is only reliable when the=
 source and target are basically identical in platform and software.=C2=A0 =
It cannot be expected to work between major versions.</div><div class=3D"gm=
ail_default" style=3D"font-family:arial,helvetica,sans-serif"><br></div><di=
v class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">=
David J.</div><div class=3D"gmail_default" style=3D"font-family:arial,helve=
tica,sans-serif"><br></div></div></div>

--000000000000eadeed064f871213--