Skip to content
logo
Percona Product Documentation
Minor Upgrade of Percona Distribution for PostgreSQL
Initializing search
    percona/postgresql-docs
    percona/postgresql-docs
    • Percona Distribution for PostgreSQL 14 Documentation
        • Overview
        • Install on Debian and Ubuntu
        • Install on RHEL and derivatives
        • Enable Percona Distribution for PostgreSQL extensions
        • Repositories overview
      • Migrate from PostgreSQL to Percona Distribution for PostgreSQL
      • Upgrading Percona Distribution for PostgreSQL from 13 to 14
      • Minor Upgrade of Percona Distribution for PostgreSQL
      • pg-stat-monitor
        • High availability
        • Deploying on Debian or Ubuntu
        • Deploying on RHEL or CentOS
        • Testing the Patroni PostgreSQL Cluster
        • Backup and disaster recovery
        • Deploying backup and disaster recovery solution in Percona Distribution for PostgreSQL
      • LDAP authentication
    • Uninstall
      • Release notes index
      • Percona Distribution for PostgreSQL 14.7 (2023-03-23)
      • Percona Distribution for PostgreSQL 14.6 (2022-11-23)
      • Percona Distribution for PostgreSQL 14.5 (2022-09-05)
      • Percona Distribution for PostgreSQL 14.4 (2022-06-27)
      • Percona Distribution for PostgreSQL 14.3 (2022-06-01)
      • Percona Distribution for PostgreSQL 14.2 Second Update (2022-05-05)
      • Percona Distribution for PostgreSQL 14.2 Update (2022-04-14)
      • Percona Distribution for PostgreSQL 14.2 (2022-03-16)
      • Percona Distribution for PostgreSQL 14.1 Second Update (2021-12-07)
      • Percona Distribution for PostgreSQL 14.1 Update (2021-12-02)
      • Percona Distribution for PostgreSQL 14.1 (2021-11-22)
    • Licensing

    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. Stopping the postgresql cluster;

    2. Installing new version packages;

    3. Restarting 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. Refer to Percona Software Repositories Documentation for update instructions.

    Important

    Run all commands as root or via sudo.

    1. Stop the postgresql service.

      $ sudo systemctl stop postgresql.service
      
      $ sudo systemctl stop postgresql-14
      
    2. Install new version packages. See Installing Percona Distribution for PostgreSQL.

    3. Restart the postgresql service.

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

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

    Contact Us

    For free technical help, visit the Percona Community Forum.

    To report bugs or submit feature requests, open a JIRA ticket.

    For paid support and managed or consulting services , contact Percona Sales.


    Last update: December 5, 2022
    Created: June 4, 2021
    Percona LLC, © 2023
    Made with Material for MkDocs

    Cookie consent

    We use cookies to recognize your repeated visits and preferences, as well as to measure the effectiveness of our documentation and whether users find what they're searching for. With your consent, you're helping us to make our documentation better.