Migrating PostgreSQL databases from RHEL 8 to RHEL 9

This article provides documentation resources for migrating PostgreSQL databases from Red Hat Enterprise Linux (RHEL) 8 to RHEL 9.

RHEL 8 includes the following PostgreSQL versions:

• PostgreSQL 10 as the postgresql:10 module stream (the default stream; available since RHEL 8.0)
• PostgreSQL 9.6 as the postgresql:9.6 module stream (no longer supported)
• PostgreSQL 12 as the postgresql:12 module stream (since RHEL 8.1.1)
• PostgreSQL 13 as the postgresql:13 module stream (since RHEL 8.4)

RHEL 9 is distributed with:

• PostgreSQL 13 as an RPM package (since RHEL 9.0)
• Additional PostgreSQL versions will be provided as modules with a shorter life cycle in future minor releases of RHEL 9.

For detailed instructions on migration, see Migrating to a RHEL 9 version of PostgreSQL.

IMPORTANT: Before migration, back up all your data stored in the PostgreSQL databases. By default, all data is stored in the /var/lib/pgsql/data/ directory on both the RHEL 8 and RHEL 9 systems.

Additional resources:

• Using PostgreSQL in RHEL 8
• Using PostgreSQL in RHEL 9
• RHEL Application Streams Life Cycle