On Wed, Dec 4, 2024 at 8:03 AM Siddhartha Jain <siddharthajain92@xxxxxxxxx> 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!
