Percona Distribution for PostgreSQL 14 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_userpart ofpgAuditextension 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 (Tech Preview Feature 1) 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.
-
A collection of additional PostgreSQL contrib extensions
Seealso
Blog Posts
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.” 2
Installation and Upgrade¶
Extensions¶
Uninstall¶
Uninstalling Percona Distribution for PostgreSQL
Release Notes¶
Reference¶
-
Tech Preview Features are not yet ready for enterprise use and are not included in support via SLA (Service License Agreement). They are included in this release so that users can provide feedback prior to the full release of the feature in a future release (or removal of the feature if it is deemed not useful). This functionality can change (APIs, CLIs, etc.) from tech preview to GA. ↩