# Percona Distribution for PostgreSQL 14.7 (2023-03-23)


| Release date:     | March 23, 2023        |
|:------------------|:-----------------------|
| **Installation**: | [Installing Percona Distribution for PostgreSQL](installing.md) |


Percona Distribution for PostgreSQL is a collection of tools to assist you in managing PostgreSQL. Percona Distribution for PostgreSQL
installs PostgreSQL and complements it by a selection of extensions that
enable solving essential practical tasks efficiently.

This release of Percona Distribution for PostgreSQL is based on [PostgreSQL 14.7](https://www.postgresql.org/docs/14/release-14-7.html). 

## Release Highlights

* A new major version of [`pg_stat_monitor` 2.0.0](https://docs.percona.com/pg-stat-monitor/release-notes/2.0.0.html) has been released and is now generally available with Percona Distribution for PostgreSQL.
* Added a new extension [`pgpool`](https://www.pgpool.net/docs/43/en/html/index.html) - a middleware between PostgreSQL server and client for high availability, connection pooling and load balancing.
* Percona Distribution for PostgreSQL is now available on Red Hat Enterprise Linux 9 and compatible derivatives

----------------------------------------------------------------------------

The following is the list of extensions available in Percona Distribution for PostgreSQL.

| Extension           | Version        | Description                  |
| ------------------- | -------------- | ---------------------------- |
| [Patroni](https://patroni.readthedocs.io/en/latest/) | 3.0.1 | a HA (High Availability) solution for PostgreSQL |
| [PgAudit](https://www.pgaudit.org/)             | 1.6.2   | provides detailed session or object audit logging via the standard logging facility provided by PostgreSQL                |
| [pgAudit set_user](https://github.com/pgaudit/set_user)| 4.0.1 | provides an additional layer of logging and control when unprivileged users must escalate themselves to superusers or object owner roles in order to perform needed maintenance tasks.|
| [pgBackRest](https://pgbackrest.org/)           | 2.43    | a backup and restore solution for PostgreSQL       |
|[pgBadger](https://github.com/darold/pgbadger)   | 12.0     | a fast PostgreSQL Log Analyzer.|
|[PgBouncer](https://www.pgbouncer.org/)          |1.18.0    | a lightweight connection pooler for PostgreSQL|
| [pg_repack](https://github.com/reorg/pg_repack) | 1.4.8   | rebuilds PostgreSQL database objects           |
| [pg_stat_monitor](https://github.com/percona/pg_stat_monitor)                                         |2.0.0 | collects and aggregates statistics for PostgreSQL and provides histogram information.|
| [PostgreSQL Common](https://salsa.debian.org/postgresql/postgresql-common)| 247 | PostgreSQL database-cluster manager. It provides a structure under which multiple versions of PostgreSQL may be installed and/or multiple clusters maintained at one time.|
|[wal2json](https://github.com/eulerto/wal2json)  |2.5       | a PostgreSQL logical decoding JSON output plugin|
|[HAProxy](http://www.haproxy.org/) | 2.5.11 | a high-availability and load-balancing solution |
| [pgpool](https://git.postgresql.org/gitweb/?p=pgpool2.git;a=summary) | 4.4.2 | a middleware between PostgreSQL server and client for high availability, connection pooling and load balancing|

Percona Distribution for PostgreSQL also includes the following packages:

* `llvm` 12.0.1 packages for Red Hat Enterprise Linux 8 and derivatives. This fixes compatibility issues with LLVM from upstream.
* supplemental `ETCD` packages which can be used for setting up Patroni clusters. These packages are available for the following operating systems:

|  Operating System   | Package              | Version | Description        |
| ------------------- | ---------------------| --------| ------------------ |
| RHEL 7              |`python3-python-etcd` | 0.4.3   | A Python client for ETCD     |
| RHEL 8              | `etcd`               | 3.3.11  | A consistent, distributed key-value store|
|                     | `python3-python-etcd`| 0.4.3   | A Python client for ETCD     |


                                                      
Percona Distribution for PostgreSQL is also shipped with the [libpq](https://www.postgresql.org/docs/14/libpq.html) 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."