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 the upgrade, update the percona-release utility to the latest version. This is required to install the new version packages of Percona Distribution for PostgreSQL.

Run all commands as root or via sudo:

  1. Stop the postgresql service.

    $ sudo systemctl stop postgresql.service
    
    $ sudo systemctl stop postgresql-12
    
  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-12
    

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

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.