Skip to content
logo
Percona Product Documentation
Percona Distribution for PostgreSQL 13 Documentation
Initializing search
    percona/postgresql-docs
    percona/postgresql-docs
    • Percona Distribution for PostgreSQL 13 Documentation
      • Installation and Upgrade
      • Extensions
      • Solutions
      • Uninstall
      • Release Notes
      • Reference
      • Installation and update
      • Installing Percona Distribution for PostgreSQL
      • Migrate from PostgreSQL to Percona Distribution for PostgreSQL
      • Upgrading Percona Distribution for PostgreSQL from 12 to 13
      • Minor Upgrade of Percona Distribution for PostgreSQL
        • pg_stat_monitor
        • High Availability in PostgreSQL with Patroni
        • Deploying on Debian or Ubuntu
        • Deploying on RHEL or CentOS
        • Testing the Patroni PostgreSQL Cluster
        • Backup and disaster recovery in Percona Distribution for PostgreSQL
        • Deploying backup and disaster recovery solution in Percona Distribution for PostgreSQL
        • LDAP Authentication
      • Uninstalling Percona Distribution for PostgreSQL
      • Release Notes
      • Percona Distribution for PostgreSQL 13.7 (2022-06-02)
      • Percona Distribution for PostgreSQL 13.6 Second Update (2022-05-05)
      • Percona Distribution for PostgreSQL 13.6 Update (2022-04-14)
      • Percona Distribution for PostgreSQL 13.6 (2022-03-22)
      • Percona Distribution for PostgreSQL 13.5 Second Update (2021-12-07)
      • Percona Distribution for PostgreSQL 13.5 Update (2021-02-12)
      • Percona Distribution for PostgreSQL 13.5 (2021-11-23)
      • Percona Distribution for PostgreSQL 13.4 Update (2021-09-30)
      • Percona Distribution for PostgreSQL 13.4 (2021-09-09)
      • Percona Distribution for PostgreSQL 13.3 Third Update (2021-07-15)
      • Percona Distribution for PostgreSQL 13.3 Second Update (2021-07-01)
      • Percona Distribution for PostgreSQL 13.3 Update (2021-06-10)
      • Percona Distribution for PostgreSQL 13.3 (2021-05-20)
      • Percona Distribution for PostgreSQL 13.2 Fourth Update (2021-06-10)
      • Percona Distribution for PostgreSQL 13.2 Third Update (2021-05-10)
      • Percona Distribution for PostgreSQL 13.2 Second Update (2021-04-27)
      • Percona Distribution for PostgreSQL 13.2 Update (2021-04-12)
      • Percona Distribution for PostgreSQL 13.2 (2021-03-04)
      • Percona Distribution for PostgreSQL 13.1 (2020-12-02)
      • Percona Distribution for PostgreSQL 13.0 (2020-10-16)
      • Licensing
    • Installation and Upgrade
    • Extensions
    • Solutions
    • Uninstall
    • Release Notes
    • Reference

    Percona Distribution for PostgreSQL 13 Documentation¶

    Percona Distribution for PostgreSQL is a collection of tools to assist you in managing your PostgreSQL database system: it installs PostgreSQL and complements it by a selection of extensions that enable solving essential practical tasks efficiently:

    • pg_repack rebuilds PostgreSQL database objects

    • pgAudit provides detailed session or object audit logging via the standard PostgreSQL logging facility

    • pgAudit set_user - The set_user part of pgAudit extension provides an additional layer of logging and control when unprivileged users must escalate themselves to superuser or object owner roles in order to perform needed maintenance tasks.

    • pgBackRest is a backup and restore solution for PostgreSQL

    • Patroni is an HA (High Availability) solution for PostgreSQL.

    • pg_stat_monitor collects and aggregates statistics for PostgreSQL and provides histogram information.

    • PgBouncer - a lightweight connection pooler for PostgreSQL

    • pgBadger - a fast PostgreSQL Log Analyzer.

    • wal2json - a PostgreSQL logical decoding JSON output plugin.

    • HAProxy- a high-availability and load-balancing solution

    • A collection of additional PostgreSQL contrib extensions

    Seealso

    Blog Posts

    • pgBackRest - A Great Backup Solution and a Wonderful Year of Growth
    • Securing PostgreSQL as an Enterprise-Grade Environment

    Percona Distribution for PostgreSQL is also shipped with the libpq library. It contains “a set of library functions that allow client programs to pass queries to the PostgreSQL backend server and to receive the results of these queries.” 1

    Installation and Upgrade¶

    • Installing Percona Distribution for PostgreSQL
    • Minor Upgrade of Percona Distribution for PostgreSQL

    Extensions¶

    pg_stat_monitor

    Solutions¶

    • High Availability in PostgreSQL with Patroni

      • Deploying high-availability on Debian and Ubuntu
      • Deploying high-availability on RHEL and CentOS
      • Testing the Patroni PostgreSQL Cluster
    • Backup and disaster recovery with pgBackRest

      • Deploying backup and disaster recovery solution in Percona Distribution for PostgreSQL

    Uninstall¶

    Uninstalling Percona Distribution for PostgreSQL

    Release Notes¶

    Release notes

    Reference¶

    Licensing


    1. https://www.postgresql.org/docs/13/libpq.html ↩

    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: 2022-06-02
    Next Installation and update
    Percona LLC, © 2022
    Made with Material for MkDocs