Skip to content
Percona Software for PostgreSQL Documentation

For help, click the link below to get free database assistance or contact our experts for personalized support.

Get help from Percona

Percona Distribution for PostgreSQL 18.1.1 (2025-11-28)

Percona Distribution for PostgreSQL is a solution that includes PostgreSQL server and the collection of tools from PostgreSQL community. These tools are tested to work together and serve to assist you in deploying and managing PostgreSQL.

The aim of Percona Distribution for PostgreSQL is to address the operational issues like High-Availability, Disaster Recovery, Security, Observability, Spatial data handling, Performance and Scalability, and others that enterprises are facing.

This release of Percona Distribution for PostgreSQL is based on Percona Server for PostgreSQL 18.1.1 - a binary compatible, open source drop in replacement of PostgreSQL Community 18.1.

It introduces several major enhancements, such as:

  • Parallel logical replication for improved throughput during initial data synchronization
  • Faster in-place upgrades via pg_upgrade performance improvements
  • Enhanced monitoring with new statistics views for pg_stat_io and background writer activity
  • Security improvements, including expanded SSL/TLS configuration options
  • Performance optimizations for query execution and index management
  • Added support for asynchronous I/O (AIO) with PostgreSQL 18.1.1 which is now the default I/O mechanism.

These features make PostgreSQL 18 a major step forward in scalability, observability, and operational efficiency.

Release Highlights

This release continues to deliver Percona’s open source value-add components for enterprise use cases, including pg_stat_monitor 2.3.1 for advanced query-level observability, pg_tde 2.1 for Transparent Data Encryption and more. See the full component list below for details.

Note

To upgrade from earlier versions (e.g. Percona Distribution for PostgreSQL 17.x), follow the steps in Upgrading Percona Distribution for PostgreSQL.

pg_tde is now a standalone package

Starting with PostgreSQL 18, pg_tde is no longer shipped with the server package. If your cluster relies on pg_tde, you must install the package manually.

For more information on installing pg_tde, see Install pg_tde .

Tarball updates

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.

Addressed CVEs

This release includes important security measures that address the following CVEs: CVE-2025-12817, CVE-2025-12818. For more details, see the PostgreSQL 18.1 release notes.

Known Issues

For minor & major upgrades (RHEL only)

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-dev

To resolve this, remove the percona-postgresql-common-dev package and reinstall it with the new intended upgraded PPG/PSP server.

MD5 Authentication Deprecated

The md5 password authentication is deprecated now and will be removed in a future release.

Supplied third-party extensions

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 3.5.24 A distributed, reliable key-value store for setting up highly available Patroni clusters
python-etcd 0.4.5 A Python client library for interacting with etcd
HAProxy 2.8.16 A high-availability and load-balancing solution
Patroni 4.1.0 A HA (High Availability) solution for PostgreSQL
PgAudit 18.0 A detailed session or object audit logging via the standard logging facility provided by PostgreSQL
pgAudit set_user 4.2.0 Provides an additional layer of logging and control when unprivileged users must escalate roles for maintenance.
pgBackRest 2.57.0 A backup and restore solution for PostgreSQL
pgBadger 13.1 A fast PostgreSQL Log Analyzer
PgBouncer 1.25.0 A lightweight connection pooler for PostgreSQL
pg_gather v32 An SQL script for running the diagnostics of the health of a PostgreSQL cluster
pgpool2 4.6.3 A middleware between PostgreSQL server and client for high availability, connection pooling, and load balancing
pg_repack 1.5.3 Rebuilds PostgreSQL database objects
pg_stat_monitor 2.3.1 Collects and aggregates statistics for PostgreSQL and provides histogram information.
pgvector v0.8.1 A vector similarity search for PostgreSQL
PostGIS 3.5.4 A spatial extension for PostgreSQL
PostgreSQL Common 287 PostgreSQL database-cluster manager. Supports multiple PostgreSQL versions and clusters simultaneously
wal2json 2.6 A PostgreSQL logical decoding JSON output plugin
pg_tde 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.”