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:
-
Stop the
postgresql
cluster -
Update
percona-release
-
Install new version packages
-
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¶
-
Update the
percona-release
utility to the latest version. This is required to install the new version packages of Percona Distribution for PostgreSQL. -
Starting with version 17.2.1,
pg_tde
is part of the Percona Server for PostgreSQL package. If you installedpg_tde
from its dedicated package, do the following to avoid conflicts during the upgrade:- Drop the extension using the
DROP EXTENSION
withCASCADE
command.
Warning: The use of the
CASCADE
parameter deletes all tables that were created in the database withpg_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 thepercona-pg_tde_17
package for RHEL and derivatives.
- Drop the extension using the
Procedure¶
Run all commands as root or via sudo:
-
Stop the
postgresql
service.$ sudo systemctl stop postgresql.service
$ sudo systemctl stop postgresql-16
-
Install new version packages. See Installing Percona Distribution for PostgreSQL.
-
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.