Percona Distribution for PostgreSQL Software (original) (raw)

The best and most critical enterprise-level components from the open-source community, designed and tested to work together in one single source by Percona Team.

Meeting the needs of the modern enterprise

Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open source community, in a single distribution, designed and tested to work together. Patroni, pgBackRest, pg_repack, and pgaudit are among the innovative components we utilize.

Backed by Percona’s world-class support and engineering teams, Percona Distribution for PostgreSQL gives companies the peace of mind that these components are tested and configured to work together, with 24×7 support.

High availability, backup, and recovery solutions keep your business-critical workloads up and running.

A robust access control system, backup encryption, and auditing capabilities ensure your data is kept safe.

Our PostgreSQL tools allow you to optimize space, enhance query performance, and make efficient use of your database resources.

A complete PostgreSQL solution that enables you to easily customize the database for your specific application and environment needs.

Key features of Percona Distribution for PostgreSQL

A single installation of Percona Distribution for PostgreSQL offers a complete package. The components are meticulously selected and tested to work together and address a broad range of production deployment use cases. Percona ensures that they are continuously updated, assisting DBAs and developers with common requirements like monitoring, high availability, and backup.

Components include:

• PostGIS support for geographic objects.
• 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.
• etcd– a distributed, reliable key-value store for setting up highly available Patroni clusters
• pgpool-ll – a middleware between PostgreSQL server and client for high availability, connection pooling and load balancing.
• pgvector – an extension that allows to store, query and index vectors, making PostgreSQL a vector database.