Skip to content
Percona Software for PostgreSQL Documentation

Rate this page
☆ ☆ ☆ ☆ ☆
Thanks for your feedback
Thank you! The feedback has been submitted.

Get free database assistance or contact our experts for personalized support.

Get help from Percona

Repositories overview

Percona provides two repositories for Percona Distribution for PostgreSQL.

Major release repository Minor release repository
Major Release repository (ppg-16) it includes the latest version packages. Whenever a package is updated, the package manager of your operating system detects that and prompts you to update. As long as you update all Distribution packages at the same time, you can ensure that the packages you’re using have been tested and verified by Percona.

We recommend installing Percona Distribution for PostgreSQL from the Major Release repository		 Minor Release repository includes a particular minor release of the database and all of the packages that were tested and verified to work with that minor release (e.g. ppg-16.0). You may choose to install Percona Distribution for PostgreSQL from the Minor Release repository if you have decided to standardize on a particular release which has passed rigorous testing procedures and which has been verified to work with your applications. This allows you to deploy to a new host and ensure that you’ll be using the same version of all the Distribution packages, even if newer releases exist in other repositories.

The disadvantage of using a Minor Release repository is that you are locked in this particular release. When potentially critical fixes are released in a later minor version of the database, you will not be prompted for an upgrade by the package manager of your operating system. You would need to change the configured repository in order to install the upgrade.

Repository contents

Percona Distribution for PostgreSQL provides individual packages for its components. It also includes two meta-packages: percona-ppg-server and percona-ppg-server-ha.

Using a meta-package, you can install all components it contains in one go.

Note

Meta packages are deprecated and will be removed in future releases.

percona-ppg-server

percona-ppg-server-16

percona-ppg-server16

The percona-ppg-server meta-package installs the PostgreSQL server with the following packages:

Package contents Description
percona-postgresql16-server The PostgreSQL server package.
percona-postgresql-common PostgreSQL database-cluster manager. It provides a structure under which multiple versions of PostgreSQL may be installed and/or multiple clusters maintained at one time.
percona-postgresql16-contrib A collection of additional PostgreSQLcontrib extensions
percona-pg-stat-monitor16 A Query Performance Monitoring tool for PostgreSQL.
percona-pgaudit16 Provides detailed session or object audit logging via the standard PostgreSQL logging facility.
percona-pg_repack16 rebuilds PostgreSQL database objects.
percona-wal2json16 a PostgreSQL logical decoding JSON output plugin.

percona-ppg-server-ha

percona-ppg-server-ha-16

percona-ppg-server-16

The percona-ppg-server-ha meta-package installs high-availability components that are recommended by Percona:

Package contents Description
percona-patroni A high-availability solution for PostgreSQL.
percona-haproxy A high-availability and load-balancing solution
etcd A consistent, distributed key-value store
python3-python-etcd A Python client for etcd

Tech Preview: PSP 16 testing repository

Tech Preview

This is a Tech Preview feature. Percona doesn’t recommend Tech Preview features for production environments. We provide them to give users early access to new functionality and the opportunity to provide feedback while the feature is still under development. There is no commitment to support them long-term, and the feature may change or be removed without notice.

Percona Server for PostgreSQL (PSP) 16.14, built with the pg_tde extension included natively, is available for evaluation through a dedicated testing repository. This is not a GA release of Percona Distribution for PostgreSQL 16 - it’s a separate, experimental build for users who want to try pg_tde and the other bundled components ahead of a full release.

Enable the testing repository with the percona-release utility:

$ sudo percona-release enable-only psp-16

Once the repository is enabled, follow the same package installation steps as Install via apt or Install via yum, skipping the percona-release setup ppg-16 step since the testing repository is already enabled.

To enable and use pg_tde, follow the steps in the pg_tde documentation to configure it.

For the full list of bundled extensions and their versions, see Percona-authored extensions. Docker images for this Tech Preview are also available - see Run in Docker.