Performing a minor version upgrade on an RPM installation v16
If you're upgrading a Red Hat Enterprise Linux-based system or a compatible system such as Rocky Linux, Alma Linux, Oracle Linux, then you used an RPM package to install EDB Postgres Advanced Server. To perform a minor upgrade on these systems, use the dnf package manager.
Note
This procedure performs an upgrade only between minor EDB Postgres Advanced Server releases. To upgrade to a later major release, use the pg_upgrade procedure.
To list the package updates that are available for your system, open a command line, assume root privileges, and run:
dnf check-update <package_name>
Where
package_nameis the search term for which you want to list available updates. You can include wildcard values in the search to list multiple related packages with a single command. For example, use the following command to list all packages with names that start withedb:dnf check-update edb*
After you identify the packages, update them:
dnf update <package_name>
Where
package_nameis the name of the package you want to update. You can include wildcard values to update multiple related packages with a single command. For example, use the following command to update all packages with names that start withedb:dnf update edb*
Restart your server to complete the upgrade.
For more information about using dnf commands and options, enter dnf --help at the command line.
Important
If upgrading to version 15.4 or later, run edb_sqlpatch.
The command might respond that it has a number of patches needing to be applied, for example:
* database edb
0 patches were previously applied to this database.
58 patches need to be applied to this database.In this case, you need to run edb_sqlpatch to patch the system catalog:
edb_sqlpatch -afFor more information about using edb_sqlpatch commands and options, see edb_sqlpatch.