MIME-Version: 1.0
References: <6E6059F6-E5A1-4A8D-8A5E-A41B921BBE67@gmail.com>
In-Reply-To: <6E6059F6-E5A1-4A8D-8A5E-A41B921BBE67@gmail.com>
From: Thomas Boussekey <thomas.boussekey@gmail.com>
Date: Tue, 11 Mar 2025 17:30:27 +0100
Message-ID: <CALUeYmfgCgoyAsvJWTDZvZ6ury9QDpn3NZSzH80CvzHLdWFCHg@mail.gmail.com>
Subject: Re: Moving from Linux to Linux?
To: Paul Foerster <paul.foerster@gmail.com>
Cc: Pgsql-General List <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e7f5f80630139b0b"
Archived-At: <https://www.postgresql.org/message-id/CALUeYmfgCgoyAsvJWTDZvZ6ury9QDpn3NZSzH80CvzHLdWFCHg%40mail.gmail.com>
Precedence: bulk

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

Hello,

Le mar. 11 mars 2025 =C3=A0 17:23, Paul Foerster <paul.foerster@gmail.com> =
a
=C3=A9crit :

> Hi,
>
> we are considering changing the PostgreSQL platform from SUSE SLE to Red
> Hat. To keep service interruptions as short as possible, the idea is to s=
et
> up a streaming replication from the SUSE server to be replaced to a
> temporary Red Hat server and then replace that SUSE server with the newly
> setup Red Hat server.
>
> My idea is to set up a streaming replication for this. But this of course
> only works if the data files would be binary compatible.
>
It seems to be possible, see this conference talk:
https://youtu.be/LFHI58JCm0Q?si=3DEWeXrKmCURTz_VN-
They have performed a linux migration with physical replication, but there
are many pitfalls around!

I have performed the same kind of migration with logical replication and,
in my context, it was far easier!

>
> So, I wonder, if this is possible. We have a lot of databases, some of
> them need to be highly available and some are large too.
>
> Are there any obstacles that definitely make that a no-go? Do I risk
> corruption? It's both Linux, just a different distribution.
>
The version of the glibc binary seems to be a determining factor

>
> Cheers,
> Paul
>
> HTH, Thomas

--000000000000e7f5f80630139b0b
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:verdana,sans-serif;color:rgb(51,51,153)">Hello,</div></div><br><di=
v class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gma=
il_attr">Le=C2=A0mar. 11 mars 2025 =C3=A0=C2=A017:23, Paul Foerster &lt;<a =
href=3D"mailto:paul.foerster@gmail.com">paul.foerster@gmail.com</a>&gt; a =
=C3=A9crit=C2=A0:<br></div><blockquote class=3D"gmail_quote" style=3D"margi=
n:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex=
">Hi,<br>
<br>
we are considering changing the PostgreSQL platform from SUSE SLE to Red Ha=
t. To keep service interruptions as short as possible, the idea is to set u=
p a streaming replication from the SUSE server to be replaced to a temporar=
y Red Hat server and then replace that SUSE server with the newly setup Red=
 Hat server.<br>
<br>
My idea is to set up a streaming replication for this. But this of course o=
nly works if the data files would be binary compatible.<br></blockquote><di=
v><span class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;col=
or:rgb(51,51,153)">It seems to be possible, see this conference talk:=C2=A0=
<a href=3D"https://youtu.be/LFHI58JCm0Q?si=3DEWeXrKmCURTz_VN-">https://yout=
u.be/LFHI58JCm0Q?si=3DEWeXrKmCURTz_VN-</a><br></span><span class=3D"gmail_d=
efault" style=3D"font-family:verdana,sans-serif;color:rgb(51,51,153)">They =
have performed a linux migration with physical replication, but there are m=
any pitfalls around!</span></div><div><br></div><div class=3D"gmail_default=
" style=3D"font-family:verdana,sans-serif;color:rgb(51,51,153)">I have perf=
ormed the same kind of migration with logical replication and, in my contex=
t, it was far easier!</div><blockquote class=3D"gmail_quote" style=3D"margi=
n:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex=
">
<br>
So, I wonder, if this is possible. We have a lot of databases, some of them=
 need to be highly available and some are large too.<br>
<br>
Are there any obstacles that definitely make that a no-go? Do I risk corrup=
tion? It&#39;s both Linux, just a different distribution.<br></blockquote><=
div><span class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;c=
olor:rgb(51,51,153)">The version of the glibc binary seems to be a determin=
ing factor=C2=A0</span>=C2=A0</div><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex">
<br>
Cheers,<br>
Paul<br>
<br></blockquote><div><span class=3D"gmail_default" style=3D"font-family:ve=
rdana,sans-serif;color:rgb(51,51,153)">HTH, Thomas</span>=C2=A0</div></div>=
</div>

--000000000000e7f5f80630139b0b--