Обсуждение: Supported RHEL version for PostgreSQL 11

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