--8<-- "release-notes-intro.md"
This release of Percona Distribution for PostgreSQL is based on Percona Server for PostgreSQL 17.7.1 - a binary compatible, open source drop in replacement of PostgreSQL Community 17.7 :octicons-link-external-16:.
!!! important PostgreSQL RPMs rebuilt to disable debug assertions
The Percona Server for PostgreSQL (PSP) and Percona Distribution for PostgreSQL (PPG) RPM packages for **PostgreSQL versions 13 through 18 released as part of the Q3 and Q4 quarterly release** were built with debug assertions enabled (`--enable-cassert`).
If you installed or updated PostgreSQL RPMs within the last four months, you may suffer performance degradation: 18.1, 17.6, 17.7, 16.10, 16.11, 15.14, 15.15, 14.19, 14.20, 13.22, 13.23.
These packages have been rebuilt, and all users running RPM-based installations of the affected releases are **strongly advised** to update to the latest available packages.
To verify, run `pg_config --configure`. If the output includes `--enable-cassert`, then your installation is affected.Starting with this release, pg_tde is no longer shipped with Percona Server for PostgreSQL. However, pg_tde is installed automatically as a hard dependency. This ensures that minor updates do not break clusters that use Transparent Data Encryption (TDE).
For more information on installing pg_tde, see Install pg_tde :octicons-link-external-16:.
Clusters that already have pg_tde in shared_preload_libraries will continue to operate normally after a minor upgrade.
No user action is required.
!!! note
Although pg_tde is installed automatically, when upgrading to PostgreSQL 18 it will not install it as a dependency. If your cluster uses TDE, you must install pg_tde manually before starting PostgreSQL 18.
The percona_pg_telemetry extension has been deprecated and replaced with a backwards compatibility stub to avoid breaking existing installations.
No telemetry data will be gathered, it will not be maintained going forward and it should not be used in new deployments.
The binary tarballs for x86_64 and ARM64 architectures have been updated in this release. The following libraries and components have new versions:
- pgbouncer: 1.25.0
- pgpool2: 4.6.3
- etcd: 3.5.24
- PostGIS: 3.5.4
- set_user: 4.2.0
- pg_repack: 1.5.3
- pg_stat_monitor: 2.3.1
- pgBackRest: 2.57.0
- Patroni: 4.1.0
- HAProxy: 2.8.16
- pgvector: 0.8.1
- libxml2: 2.12.10
- pg_tde: 2.1.0
See Install Percona Distribution for PostgreSQL from binary tarballs for the download links.
This release includes important security measures that address the following CVEs: CVE-2025-12817, CVE-2025-12818. For more details, see the PostgreSQL 17.7 release notes :octicons-link-external-16:.
During an upgrade on RHEL, you may encounter the following error:
Unknown Error occurred: Transaction test error:
file /usr/share/postgresql-common/server/postgresql.mk from install of percona-postgresql-common conflicts with file from package percona-postgresql-common-dev
file /usr/share/postgresql-common/t/040_upgrade.t from install of percona-postgresql-common conflicts with file from package percona-postgresql-common-devTo resolve this, remove the percona-postgresql-common-dev package and reinstall it with the new intended upgraded PPG/PSP server.
Review each extension’s release notes for What’s new, improvements, or bug fixes.
The following is the list of extensions available in Percona Distribution for PostgreSQL.
| Extension | Version | Description |
|---|---|---|
| etcd :octicons-link-external-16: | 3.5.24 | A distributed, reliable key-value store for setting up highly available Patroni clusters |
| python-etcd :octicons-link-external-16: | 0.4.5 | A Python client library for interacting with etcd |
| HAProxy :octicons-link-external-16: | 2.8.16 | A high-availability and load-balancing solution |
| Patroni :octicons-link-external-16: | 4.1.0 | A HA (High Availability) solution for PostgreSQL |
| PgAudit :octicons-link-external-16: | 17.1 | A detailed session or object audit logging via the standard logging facility provided by PostgreSQL |
| pgAudit set_user :octicons-link-external-16: | 4.2.0 | Provides an additional layer of logging and control when unprivileged users must escalate roles for maintenance. |
| pgBackRest :octicons-link-external-16: | 2.57.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.25.0 | A lightweight connection pooler for PostgreSQL |
| pg_gather :octicons-link-external-16: | v32 | An SQL script for running the diagnostics of the health of a PostgreSQL cluster |
| pgpool2 :octicons-link-external-16: | 4.6.3 | A middleware between PostgreSQL server and client for high availability, connection pooling, and load balancing |
| pg_repack :octicons-link-external-16: | 1.5.3 | Rebuilds PostgreSQL database objects |
| pg_stat_monitor | 2.3.1 | Collects and aggregates statistics for PostgreSQL and provides histogram information. |
| pgvector :octicons-link-external-16: | v0.8.1 | A vector similarity search for PostgreSQL |
| PostGIS :octicons-link-external-16: | 3.5.4 | A spatial extension for PostgreSQL |
| PostgreSQL Common :octicons-link-external-16: | 287 | 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 |
| pg_tde :octicons-link-external-16: | v2.1.0 | A PostgreSQL extension that provides Transparent Data Encryption (TDE) to protect data at rest |
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."