On Sat, Aug 28, 2021 at 04:08:33PM +0800, Sudhir Guna wrote: > The RHEL upgrade from 7.5 to 8.4 is not done as an incremental version > upgrade rather directly from 7.5. I think the process should be: 1) upgrade from RH7 to RH8; 2) reindex relevant indexes (see wiki link below); 3) upgrade from postgres 9.6 to 11; You may need to install updated PGDG packages for the RH8. How are you planning to upgrade postgres ? Using pg_upgrade, or pg_dump, or ?? > Postgres is installed using PGDG packages. > > On Thu, Aug 26, 2021 at 1:15 AM Justin Pryzby <pryzby@xxxxxxxxxxxxx> wrote: > > > On Wed, Aug 25, 2021 at 11:47:57PM +0800, Sudhir Guna wrote: > > > Hi All, > > > > > > I would like to clarify on OS upgrade for PostgreSQL. > > > > > > Currently we are on PostgreSQL 9.6 on RHEL 7.5. We would like to do a > > > direct upgrade from RHEL 7.5 to RHEL 8.4 and then upgrade PostgreSQL 9.6 > > to > > > PostgreSQL 11. > > > > > > Is it ok to do a direct upgrade from RHEL 7.5 to RHEL 8.4 > > > > Please describe what you mean by a "direct upgrade" ? > > > > You should be careful, since the sort order of indexes can change: > > https://wiki.postgresql.org/wiki/Locale_data_changes > > | Version 8 uses the new locale data. Therefore, caution will be necessary > > when upgrading. > > > > > Is PostgreSQL 11 compatible with RHEL 8.4 > > > > How did you install postgres ? > > Compiled from source ? > > Using RHEL packages ? > > Using PGDG packages ? > > > > PDDG has pacakges for PG11/RH8 > > https://yum.postgresql.org/rpmchart/#pg11
