MIME-Version: 1.0
References: <6E6059F6-E5A1-4A8D-8A5E-A41B921BBE67@gmail.com>
In-Reply-To: <6E6059F6-E5A1-4A8D-8A5E-A41B921BBE67@gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 11 Mar 2025 12:32:39 -0400
Message-ID: <CANzqJaDbA-iZ4f8C5V7nmAJr1HH3AGcDNxj-R=2BrMOE8vPD3w@mail.gmail.com>
Subject: Re: Moving from Linux to Linux?
To: Pgsql-General List <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ca7f4a063013a384"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDbA-iZ4f8C5V7nmAJr1HH3AGcDNxj-R%3D2BrMOE8vPD3w%40mail.gmail.com>
Precedence: bulk

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

On Tue, Mar 11, 2025 at 12:23=E2=80=AFPM Paul Foerster <paul.foerster@gmail=
.com>
wrote:

> 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.
>
> 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 same version of PG will be on both, right?

What version of RHEL?  What version of SLES?  Those questions are proxy
for: what version of glibc on each system?

If they're the same, and you use libc for collation, then you're (probably)
good to go.

If they're different, then you should use logical replication.  Otherwise,
string collation mismatch could bite you on any indices on text fields.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Mar 11, 2025 at 12:23=E2=80=AFPM =
Paul Foerster &lt;<a href=3D"mailto:paul.foerster@gmail.com">paul.foerster@=
gmail.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_contain=
er"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bor=
der-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>
<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><br></div><div>The same version of PG will be on both, right?</div><div=
></div></div><div><br clear=3D"all"></div><div>What version of RHEL?=C2=A0 =
What version of SLES?=C2=A0 Those questions are proxy for: what version of =
glibc on each system?</div><div><br></div><div>If they&#39;re=C2=A0the same=
, and you use libc for collation, then you&#39;re (probably) good to go.</d=
iv><div><br></div><div>If they&#39;re different, then you should use logica=
l replication.=C2=A0 Otherwise, string collation mismatch could bite you on=
 any indices on text fields.</div><div><br></div><span class=3D"gmail_signa=
ture_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div =
dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil=
 me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div=
></div></div></div></div>

--000000000000ca7f4a063013a384--