Skip to content
Percona Documentation

Percona Distribution for PostgreSQL 16 Documentation

Percona Distribution for PostgreSQL is a suite of open source software, tools and services required to deploy and maintain a reliable production cluster for PostgreSQL. It includes native PostgreSQL server, enhanced with extensions from open source community that are certified and tested to work together for high availability, backups, security, and monitoring that help ensure the cluster’s peak performance.

Part of the solution, Percona Operator for PostgreSQL, makes it easy to orchestrate the cluster reliably and repeatably in Kubernetes.

What’s included in Percona Distribution for PostgreSQL?

What’s in it for you?

  • No vendor lock in - all components of Percona Distribution for PostgreSQL are fully open source
  • No guesswork on finding the right version of a component – they all undergo thorough testing to ensure compatibility
  • Freely available reference architectures for solutions like high-availability, backups and disaster recovery
  • Spatial data handling support via PostGIS
  • Monitoring of the database health, performance and infrastructure usage via open source Percona Management and Monitoring with PostgreSQL-specific dashboards
  • Run PostgreSQL on Kubernetes using open source Percona Operator for PostgreSQL. It not only automates deployment and management of PostgreSQL clusters on Kubernetes, but also includes enterprise-ready features for high-availability, backup and restore, replication, logging, and more

Installation guides

Get started quickly with the step-by-step installation instructions.

Quickstart guides

Solutions

Check our solutions to build the database infrastructure that meets the requirements of your organization - be it high-availability, disaster recovery or spatial data handling.

Solutions

Troubleshooting and FAQ

Our comprehensive resources will help you overcome challenges, from everyday issues to specific doubts.

Troubleshooting

📢 What’s new?

Learn about the releases and changes in the Distribution.

Release notes

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

  • 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

  • pgBadger - a fast PostgreSQL Log Analyzer.

  • PgBouncer - a lightweight connection pooler for PostgreSQL

  • pg_gather - an SQL script to assess the health of PostgreSQL cluster by gathering performance and configuration data from PostgreSQL databases.

  • pgpool2 - a middleware between PostgreSQL server and client for high availability, connection pooling and load balancing.

  • pg_repack rebuilds PostgreSQL database objects

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

  • PostGIS allows storing and manipulating spacial data in PostgreSQL.

  • wal2json - a PostgreSQL logical decoding JSON output plugin.

  • A collection of additional PostgreSQL contrib extensions

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.

Community Forum Get a Percona Expert