Request a Demo
Home   >   mailing lists

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

From Ron Johnson
Subject Re: OS upgrade on postgres servers
Date
Msg-id CANzqJaBeJzmsF+OE8v8BR6v72WChr5F+4WUjRuzZ1dxb9UzwgA@mail.gmail.com
Whole thread
In response to Re: OS upgrade on postgres servers  (Raj <rajeshkumar.dba09@gmail.com>)
Responses Re: OS upgrade on postgres servers
List pgsql-admin
Tree view


On Mon, Mar 16, 2026 at 3:45 PM Raj <rajeshkumar.dba09@gmail.com> wrote:
Pgdg repo
100Gb

That's relatively small.  Parallel pg_dump/pg_restore should be pretty fast.
 
Outage window - our decision. Client will accept our plan.
Postgres upgrade may or may not be needed. Need help on both the scenarios 

What version of PG are you currently using?  (Everything older than PG 14 is EOL, and PG 14 will go EOL this November.)

I strongly recommend that you add the PGDG repository to yum/dnf, and then install the intended version (both before and after the upgrade to RHEL10.

PG 17.latest or PG 18.latest are best, but of course you need to read the release notes and test your application against that new version.

Then, for example:
/usr/pgsql-17/bin/pg_dump -Fd -jX ....
<upgrade RHEL to v10>
/usr/pgsql-17/bin/pg_restore -Fd -jX
 

On Tue, 17 Mar 2026, 00:41 Ron Johnson, <ronljohnsonjr@gmail.com> wrote:
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: Re: OS upgrade on postgres servers
Next
From: vrms
Date:
Subject: Re: OS upgrade on postgres servers