Percona Server for PostgreSQL

Percona Server for PostgreSQL is a binary-compatible, open source drop-in replacement for PostgreSQL 17. It functions identically to upstream PostgreSQL, allowing you to migrate seamlessly between the two.

In addition to upstream functionality, Percona Server includes enhancements that enable advanced extension capabilities.

Enhancements

• Storage Manager (SMGR) API exposure, which allows PostgreSQL extensions to integrate custom storage managers. This change was inspired by the following patchset introduced to the community.
• WAL Read/Write API exposure, which allows extensions to hook into WAL read and write operations.

These enhancements serve as the foundation for Percona-authored extensions, such as pg_tde, which enables data-at-rest encryption.

These changes do not affect existing use cases and PostgreSQL behavior. They enable additional encryption features, such as index-level and Write-Ahead Logging (WAL) encryption, through the pg_tde extension.

Percona Server and the upstream PostgreSQL operate identically, making migrations between the two straightforward.

For details about available extensions, see the Percona-authored extensions topic.

For a broader overview of integrated tooling and deployment guidance, start with the Percona Distribution for PostgreSQL Quickstart guide.

Note

The PostgreSQL Compatibility Index (PCI) test suite reported 100% compatibility. PCI validates behavioral equivalence by running a suite of compatibility checks against upstream PostgreSQL.

These results were obtained using Percona Server for PostgreSQL 17.6.1 . View the PCI test results here .