Re: OS upgrade on postgres servers - Mailing list pgsql-admin

From Ron Johnson
Subject Re: OS upgrade on postgres servers
Date
Msg-id CANzqJaDdOPGTE3wjgVA4rsPsG2j44JjvDZLKw0DFnnwauEFw8g@mail.gmail.com
Whole thread Raw
In response to OS upgrade on postgres servers  (Raj <rajeshkumar.dba09@gmail.com>)
Responses Re: OS upgrade on postgres servers
List pgsql-admin
On Mon, Mar 16, 2026 at 2:57 PM 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!

pgsql-admin by date:

Previous
From: Raj
Date:
Subject: OS upgrade on postgres servers
Next
From: Raj
Date:
Subject: Re: OS upgrade on postgres servers