Skip to content
This documentation is for the end of life version of Percona Distribution for PostgreSQL 11.
Learn more about PostgreSQL 11 end of life implications. See the current documentation.
logo
Percona Product Documentation
Repositories overview
Initializing search
    percona/postgresql-docs
    percona/postgresql-docs
    • Home
      • Release notes index
      • Percona Distribution for PostgreSQL 11.22 Update (2024-01-22)
      • Percona Distribution for PostgreSQL 11.22 (2023-12-13)
      • Percona Distribution for PostgreSQL 11.21 (2023-08-31)
      • Percona Distribution for PostgreSQL 11.20 (2023-06-30)
      • Percona Distribution for PostgreSQL 11.19 Update (2023-05-22)
      • Percona Distribution for PostgreSQL 11.19 (2023-03-31)
      • Percona Distribution for PostgreSQL 11.18 (2022-12-08)
      • Percona Distribution for PostgreSQL 11.17 (2022-09-08)
      • Percona Distribution for PostgreSQL 11.16 (2022-06-07)
      • Percona Distribution for PostgreSQL 11.15 Second Update (2022-05-05)
      • Percona Distribution for PostgreSQL 11.15 Update (2022-04-14)
      • Percona Distribution for PostgreSQL 11.15 (2022-04-08)
      • Percona Distribution for PostgreSQL 11.14 (2021-12-20)
      • Percona Distribution for PostgreSQL 11.13 Update (2021-12-07)
      • Percona Distribution for PostgreSQL 11.13 (2021-09-09)
      • Percona Distribution for PostgreSQL 11.12 Third Update (2021-07-15)
      • Percona Distribution for PostgreSQL 11.12 Second Update (2021-07-01)
      • Percona Distribution for PostgreSQL 11.12 Update (2021-06-10)
      • Percona Distribution for PostgreSQL 11.12 (2021-05-24)
      • Percona Distribution for PostgreSQL 11.11 Third Update (2021-06-10)
      • Percona Distribution for PostgreSQL 11.11 Second Update (2021-05-10)
      • Percona Distribution for PostgreSQL 11.11 Update (2021-04-12)
      • Percona Distribution for PostgreSQL 11.11 (2021-03-08)
      • Percona Distribution for PostgreSQL 11.10 Update (2021-06-10)
      • Percona Distribution for PostgreSQL 11.10 (2020-12-15)
      • Percona Distribution for PostgreSQL 11.9 (2020-09-08)
      • Percona Distribution for PostgreSQL 11.8 (2020-06-11)
      • Percona Distribution for PostgreSQL 11.7 (2020-04-09)
      • Percona Distribution for PostgreSQL 11.6 (2020-01-23)
      • Percona Distribution for PostgreSQL 11 (2019-09-17)
      • Percona Distribution for PostgreSQL 11 (Beta) (2019-05-15)
        • Overview
        • Via apt
        • Via yum
        • Enable Percona Distribution for PostgreSQL extensions
        • Repositories overview
          • Repository contents
            • percona-ppg-server
            • percona-ppg-server-ha
      • Run in Docker
      • Migrate from PostgreSQL to Percona Distribution for PostgreSQL
      • 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
        • pgBackRest setup
      • Backup and disaster recovery
        • Deploying backup and disaster recovery solution in Percona Distribution for PostgreSQL
        • Overview
        • Deployment
        • Query spatial data
        • Upgrade spatial database
      • LDAP authentication
    • Telemetry
    • Uninstall
    • Licensing
    • Trademark policy

    • Repository contents
      • percona-ppg-server
      • percona-ppg-server-ha

    Repositories overview¶

    Percona provides two repositories for Percona Distribution for PostgreSQL.

    Major release repository Minor release repository
    Major Release repository (e.g. ppg-11) 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-11.10). 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.

    percona-ppg-server¶

    percona-ppg-server-11

    percona-ppg-server11

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

    Package contents Description
    percona-postgresql11-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-postgresql11-contrib A collection of additional PostgreSQLcontrib extensions
    percona-pg-stat-monitor11 A Query Performance Monitoring tool for PostgreSQL.
    percona-pgaudit11 Provides detailed session or object audit logging via the standard PostgreSQL logging facility.
    percona-pg_repack11 rebuilds PostgreSQL database objects.
    percona-wal2json11 a PostgreSQL logical decoding JSON output plugin.

    percona-ppg-server-ha¶

    percona-ppg-server-ha-11

    percona-ppg-server-11

    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.1
    etcd-client, etcd-server The client/server of the distributed key-value store. 2

    1. Is included in repositories for RHEL 8 / CentOS 8 operating systems ↩

    2. Are included in repositories for Debian 12 operating system ↩

    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.

    December 13, 2023 September 14, 2022
    Percona LLC and/or its affiliates, © 2024 — Cookie Preferences
    Made with Material for MkDocs