MIME-Version: 1.0
References: 
 <CAJk5AtbW=741yyD5+oV9yHSU40E4g57SY5DLRcJXsEK5-YFRig@mail.gmail.com>
 <CANzqJaDdOPGTE3wjgVA4rsPsG2j44JjvDZLKw0DFnnwauEFw8g@mail.gmail.com>
In-Reply-To: 
 <CANzqJaDdOPGTE3wjgVA4rsPsG2j44JjvDZLKw0DFnnwauEFw8g@mail.gmail.com>
From: Raj <rajeshkumar.dba09@gmail.com>
Date: Tue, 17 Mar 2026 01:14:48 +0530
Message-ID: 
 <CAJk5AtaJkt1wETETV88LvY9NQwAC6KF35Q=L-rekGk=zLEfWcg@mail.gmail.com>
Subject: Re: OS upgrade on postgres servers
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000053781d064d2974a1"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJk5AtaJkt1wETETV88LvY9NQwAC6KF35Q%3DL-rekGk%3DzLEfWcg%40mail.gmail.com>
Precedence: bulk

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

Pgdg repo
100Gb
Outage window - our decision. Client will accept our plan.
Postgres upgrade may or may not be needed. Need help on both the scenarios

On Tue, 17 Mar 2026, 00:41 Ron Johnson, <ronljohnsonjr@gmail.com> wrote:

> On Mon, Mar 16, 2026 at 2:57=E2=80=AFPM Raj <rajeshkumar.dba09@gmail.com>=
 wrote:
>
>> 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?
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>

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

<div dir=3D"auto"><div>Pgdg repo</div><div dir=3D"auto">100Gb</div><div dir=
=3D"auto">Outage window - our decision. Client will accept our plan.</div><=
div dir=3D"auto">Postgres upgrade may or may not be needed. Need help on bo=
th the scenarios=C2=A0<br><br><div class=3D"gmail_quote gmail_quote_contain=
er" dir=3D"auto"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, 17 Mar 2026,=
 00:41 Ron Johnson, &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com">ronljohn=
sonjr@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" s=
tyle=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div=
 dir=3D"ltr"><div dir=3D"ltr">On Mon, Mar 16, 2026 at 2:57=E2=80=AFPM Raj &=
lt;<a href=3D"mailto:rajeshkumar.dba09@gmail.com" target=3D"_blank" rel=3D"=
noreferrer">rajeshkumar.dba09@gmail.com</a>&gt; wrote:</div><div class=3D"g=
mail_quote"><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"a=
uto">Hi all,<div dir=3D"auto"><br></div><div dir=3D"auto">I have traditiona=
l servers with postgres with replication setup (primary - standby). OS team=
 want to upgrade from rhel 8.10 to 10.</div><div dir=3D"auto"><br></div><di=
v dir=3D"auto">As a dba, what is the suggestion we need to give.=C2=A0 How =
do we proceed ? Should we stop the posygres servers? Should we get new serv=
ers with rhel 10 and migrate Data?</div></div></blockquote><div><br></div><=
div>That&#39;s certainly a safe method.</div><div>=C2=A0</div><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px soli=
d rgb(204,204,204);padding-left:1ex"><div dir=3D"auto"><div dir=3D"auto"> W=
hat&#39;s the 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>
</blockquote></div></div></div>

--00000000000053781d064d2974a1--