Minor EDB Postgres Extended Server upgrade of RPM packages v17

Suggest edits

If you used dnf to install an RPM package of EDB Postgres Extended Server (on RHEL, AlmaLinux, Rocky Linux), use dnf to perform a minor version upgrade of the packages.

Overview

  1. Check for available updates with dnf check-update.

  2. Upgrade the EDB Postgres Extended Server packages with dnf update.

  3. Restart the server with pg_ctl.

  4. Verify the server version with psql.

Worked example

  1. To list the package updates available for your system, open a command line, assume root privileges, and enter the command:

    sudo dnf check-update <package_name>

    For example, if you want to upgrade to the latest minor version of EDB Postgres Extended Server 16, run: 

    sudo dnf check-update edb-postgresextended16
    Note

    You can include wildcard values in the search term. For example, if you're looking for EDB Packages, you can run sudo dnf check-update edb-*. For more information about using dnf commands and options, enter dnf --help at the command line.

  2. Once you've figured the name and version of the package you want to install, use dnf update to install the package:

    sudo dnf update edb-postgresextended16
    Output
    ================================================================================
Package                        Arch   Version    Repository               Size
================================================================================
Upgrading:
 edb-postgresextended16         x86_64 16.3-2.el9 enterprisedb-enterprise 1.7 M
 edb-postgresextended16-contrib x86_64 16.3-2.el9 enterprisedb-enterprise 724 k
 edb-postgresextended16-libs    x86_64 16.3-2.el9 enterprisedb-enterprise 330 k
 edb-postgresextended16-server  x86_64 16.3-2.el9 enterprisedb-enterprise 6.8 M

Transaction Summary
================================================================================
Upgrade  4 Packages

Total download size: 9.5 M
Is this ok [y/N]

  3. Confirm with y. The output displays an overview of all performed processes, where you can see the packages that were upgraded:

    y
    Output
    edb-postgresextended16-16.3-2.el9.x86_64
edb-postgresextended16-contrib-16.3-2.el9.x86_64
edb-postgresextended16-libs-16.3-2.el9.x86_64
edb-postgresextended16-server-16.3-2.el9.x86_64

  4. To finalize the upgrade, restart the server. Replace <path_to_data_directory> with the path to the data directory of the server or servers you're upgrading:

    /usr/edb/pge16/bin/pg_ctl -D <path_to_data_directory> restart

    For example: 

    /usr/edb/pge16/bin/pg_ctl -D /var/lib/edb-pge/16/upgrade restart

  5. Verify the expected database version is running by connecting to psql: 

    /usr/edb/pge16/bin/psql

    Check the server version: 

    SHOW server_version;
    Output
                   server_version
--------------------------------------------
 16.3 (EDB Postgres Extended Server 16.3.0)
← Prev

Minor EDB Postgres Extended Server upgrade of Debian packages

↑ Up

Minor EDB Postgres Extended Server upgrade