--8<-- "release-notes-intro.md"
This release of Percona Distribution for PostgreSQL is based on Percona Server for PostgreSQL 17.5.2 - a binary compatible, open source drop in replacement of PostgreSQL Community 17.5.
Percona Distribution for PostgreSQL now includes the 1.0 GA release of Percona's Transparent Data Encryption for PostgreSQL.
Learn more in the pg_tde 1.0 release notes :octicons-link-external-16:.
The pg_tde documentation has received significant updates, which include:
- New KMS configuration guides for Fortanix, Vault, KMIP and OpenBAO
- Reorganized and expanded topics for Architecture, GUC, Functions, TDE Operations and FAQ
- Extensive and numerous refinements and clarifications across the entire site
Explore the full documentation in the official pg_tde documentations.
The following is the list of extensions available in Percona Distribution for PostgreSQL.
| Extension | Version | Description |
|---|---|---|
| etcd :octicons-link-external-16: | 3.5.21 | A distributed, reliable key-value store for setting up high available Patroni clusters |
| HAProxy :octicons-link-external-16: | 2.8.15 | A high-availability and load-balancing solution |
| Patroni :octicons-link-external-16: | 4.0.5 | A HA (High Availability) solution for PostgreSQL |
| PgAudit :octicons-link-external-16: | 17.1 | Provides detailed session or object audit logging via the standard logging facility provided by PostgreSQL |
| pgAudit set_user :octicons-link-external-16: | 4.1.0 | Provides an additional layer of logging and control when unprivileged users must escalate roles for maintenance. |
| pgBackRest :octicons-link-external-16: | 2.55.0 | A backup and restore solution for PostgreSQL |
| pgBadger :octicons-link-external-16: | 13.1 | A fast PostgreSQL Log Analyzer |
| PgBouncer :octicons-link-external-16: | 1.24.1 | A lightweight connection pooler for PostgreSQL |
| pg_gather :octicons-link-external-16: | v30 | An SQL script for running the diagnostics of the health of a PostgreSQL cluster |
| pgpool2 :octicons-link-external-16: | 4.6.0 | A middleware between PostgreSQL server and client for high availability, connection pooling, and load balancing |
| pg_repack :octicons-link-external-16: | 1.5.2 | Rebuilds PostgreSQL database objects |
| pg_stat_monitor | 2.2.0 | collects and aggregates statistics for PostgreSQL and provides histogram information. |
| pgvector :octicons-link-external-16: | v0.8.0 | A vector similarity search for PostgreSQL |
| PostGIS :octicons-link-external-16: | 3.3.8 | A spatial extension for PostgreSQL |
| PostgreSQL Common :octicons-link-external-16: | 277 | PostgreSQL database-cluster manager. Supports multiple PostgreSQL versions and clusters simultaneously |
| wal2json :octicons-link-external-16: | 2.6 | A PostgreSQL logical decoding JSON output plugin |
For Red Hat Enterprise Linux 8 and compatible derivatives, Percona Distribution for PostgreSQL also includes the supplemental python3-etcd 0.4.5 packages, which are used for setting up Patroni clusters.
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."