MIME-Version: 1.0
References: 
 <CAJk5AtbW=741yyD5+oV9yHSU40E4g57SY5DLRcJXsEK5-YFRig@mail.gmail.com>
In-Reply-To: 
 <CAJk5AtbW=741yyD5+oV9yHSU40E4g57SY5DLRcJXsEK5-YFRig@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Mon, 16 Mar 2026 15:11:36 -0400
Message-ID: 
 <CANzqJaDdOPGTE3wjgVA4rsPsG2j44JjvDZLKw0DFnnwauEFw8g@mail.gmail.com>
Subject: Re: OS upgrade on postgres servers
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000089a7f5064d28fdc0"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaDdOPGTE3wjgVA4rsPsG2j44JjvDZLKw0DFnnwauEFw8g%40mail.gmail.com>
Precedence: bulk

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

On Mon, Mar 16, 2026 at 2:57=E2=80=AFPM Raj <rajeshkumar.dba09@gmail.com> w=
rote:

> Hi all,
>
> I have traditional servers with postgres with replication setup (primary =
-
> standby). OS team want to upgrade from rhel 8.10 to 10.
>
> As a dba, what is the suggestion we need to give.  How do we proceed ?
> Should we stop the posygres servers? Should we get new servers with rhel =
10
> and migrate Data?
>

That's certainly a safe method.


> What's the best procedure
>

The main problem is collation change driven by the newer glibc version.

1. How did you install PG (from the RHEL repository, or from the PGDG
repository)?
2. How big are your databases?
3. How big is your outage window?
4. Do you plan on upgrading Postgresql at the same time?

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

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

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Mar 16, 2026 at 2:57=E2=80=AFPM R=
aj &lt;<a href=3D"mailto:rajeshkumar.dba09@gmail.com">rajeshkumar.dba09@gma=
il.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"=
><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border=
-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">Hi all=
,<div dir=3D"auto"><br></div><div dir=3D"auto">I have traditional servers w=
ith postgres with replication setup (primary - standby). OS team want to up=
grade from rhel 8.10 to 10.</div><div dir=3D"auto"><br></div><div dir=3D"au=
to">As a dba, what is the suggestion we need to give.=C2=A0 How do we proce=
ed ? Should we stop the posygres servers? Should we get new servers with rh=
el 10 and migrate Data?</div></div></blockquote><div><br></div><div>That=
9;s certainly a safe method.</div><div>=C2=A0</div><blockquote class=3D"gma=
il_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,2=
04,204);padding-left:1ex"><div dir=3D"auto"><div dir=3D"auto"> What&#39;s t=
he best procedure</div></div>
</blockquote></div><div><br clear=3D"all"></div><div>The main problem is co=
llation change driven by the newer glibc version.</div><div><br></div><div>=
1. How did you install PG (from the RHEL repository, or from the PGDG repos=
itory)?</div><div>2. How big are your databases?</div><div>3. How big is yo=
ur outage window?</div><div>4. Do you plan on upgrading Postgresql at the=
=C2=A0same time?</div><div><br></div><span class=3D"gmail_signature_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>

--00000000000089a7f5064d28fdc0--