Skip to content

Minor Upgrade of Percona Distribution for PostgreSQL

Minor releases of PostgreSQL include bug fixes and feature enhancements. We recommend that you keep your Percona Distribution for PostgreSQL updated to the latest minor version.

Though minor upgrades do not change the behavior, we recommend you to back up your data first, in order to be on the safe side.

Minor upgrade of Percona Distribution for PostgreSQL includes the following steps:

  1. Stop the postgresql cluster

  2. Update percona-release

  3. Install new version packages

  4. Restart the postgresql cluster.

Note

These steps apply if you installed Percona Distribution for PostgreSQL from the Major Release repository. In this case, you are always upgraded to the latest available release.

If you installed Percona Distribution for PostgreSQL from the Minor Release repository, you will need to enable a new version repository to upgrade.

For more information about Percona repositories, refer to Installing Percona Distribution for PostgreSQL.

Before you start

  1. Update the percona-release utility to the latest version. This is required to install the new version packages of Percona Distribution for PostgreSQL.

  2. Starting with version 17.2.1, pg_tde is part of the Percona Server for PostgreSQL package. If you installed pg_tde from its dedicated package, do the following to avoid conflicts during the upgrade:

    • Drop the extension using the DROP EXTENSION with CASCADE command.

    Warning: The use of the CASCADE parameter deletes all tables that were created in the database with pg_tde enabled and also all dependencies upon the encrypted table (e.g. foreign keys in a non-encrypted table used in the encrypted one).

    DROP EXTENSION pg_tde CASCADE
    
    • Uninstall the percona-postgresql-17-pg-tde package for Debian/Ubuntu or the percona-pg_tde_17 package for RHEL and derivatives.

Procedure

Run all commands as root or via sudo:

  1. Stop the postgresql service.

    $ sudo systemctl stop postgresql.service
    
    $ sudo systemctl stop postgresql-16
    
  2. Update percona-release to the latest version.

  3. Install new version packages. See Installing Percona Distribution for PostgreSQL.

  4. Restart the postgresql service.

    $ sudo systemctl start postgresql.service
    
    $ sudo systemctl start postgresql-16
    

If you wish to upgrade Percona Distribution for PostgreSQL to the major version, refer to Upgrading Percona Distribution for PostgreSQL from 16 to 17.

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.