Re: Postgres compatibility with RHEL

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgres compatibility with RHEL
Date: 2024-12-04 14:45:07
Message-ID: CANzqJaAcdNpSrhQ1K2b8cvWKnRqgSt6nEeL2gZotfK7qJe++Xw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Dec 4, 2024 at 8:03 AM Siddhartha Jain <siddharthajain92(at)gmail(dot)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!

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Henry Ashu 2024-12-06 14:15:31 How To Configure PostgreSQL to Use LDAP for Authentication
Previous Message Devrim Gündüz 2024-12-04 14:25:32 Re: Postgres compatibility with RHEL