Thread: Supported RHEL version for PostgreSQL 11
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
Is PostgreSQL 11 compatible with RHEL 8.4
Regards,
Gunar
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 -- Justin
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@telsasoft.com> 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