Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres compatibility with RHEL - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Postgres compatibility with RHEL
Date
Msg-id CANzqJaAcdNpSrhQ1K2b8cvWKnRqgSt6nEeL2gZotfK7qJe++Xw@mail.gmail.com
Whole thread Raw
In response to Postgres compatibility with RHEL  (Siddhartha Jain <siddharthajain92@gmail.com>)
List pgsql-admin
Tree view
On Wed, Dec 4, 2024 at 8:03 AM Siddhartha Jain <siddharthajain92@gmail.com> wrote:
Hi,

Please let me know if Postgresql 16 is compatible with RHEL 7.9 version and RHEL 9.1 version.
I need to upgrade postgres from 11.22 to 16.6 and need information for that as the OS version is going to upgrade from 7.9 to 9.1. 
Also, let me know the strategies if any to upgrade both RHEL and DB. 

Are you doing an in-place RHEL upgrade on the server?  If so, then I'd:
1) run pg_dump, "pg_dumpall -g", and save postgresql.conf, pg_hba.conf, etc files when the server is still RHEL 7.9 and PG 11.22, 
2) upgrade to RHEL 9.1 (out of scope for this list), 
3) install PG 16.6,
4) what you do next depends on your mount points.

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

pgsql-admin by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: Postgres compatibility with RHEL
Next
From: Henry Ashu
Date:
Subject: How To Configure PostgreSQL to Use LDAP for Authentication