Upgrade the Database

To successfully perform a major Uyuni update, you might need to upgrade the underlying database.

If you are using PostgreSQL 9, and you are upgrading to version 10, see upgrade:db-migration-10.adoc. If you are using PostgreSQL 10, and you are upgrading to version 12, see upgrade:db-migration-12.adoc.

If you want to upgrade to the latest Uyuni version, you must be using PostgreSQL version 10 or 12. If you are using an older version, such as version 9.6, you must migrate PostgreSQL to version 10 before you begin the Uyuni migration.

If you run PostgreSQL 9.4 on Uyuni 3.2, see the product documentation at https://documentation.suse.com/external-tree/en-us/suma/3.2/susemanager-best-practices/html/book.suma.best.practices/bp.sp.migration.html#sp.migration.postgresql. You cannot migrate directly from PostgreSQL 9.4 to version 10.

This table shows the PostgreSQL version required for each version of Uyuni and SUSE Linux Enterprise Server:

Table 1. PostgreSQL Versions
Uyuni version Operating System version PostgreSQL version

Uyuni 3.1.4

SLES 12 SP3

Postgres 9.6

Uyuni 3.1.11

SLES 12 SP3

Postgres 9.6

Uyuni 3.2.10

SLES 12 SP3

Postgres 9.6

Uyuni 3.2.10

SLES 12 SP3

Postgres 10

Uyuni 3.2.10

SLES 12 SP4

Postgres 10

Uyuni 4.0.0

SLES 15 SP1

Postgres 10

Uyuni 4.1.0

SLES 15 SP2

Postgres 12

Uyuni 4.2.0

SLES 15 SP3

Postgres 13