> For the complete documentation index, see [llms.txt](https://dbi-services.gitbook.io/yak-user-doc/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dbi-services.gitbook.io/yak-user-doc/release-notes/components/postgresql.md).

# PostgreSQL

{% tabs fullWidth="true" %}
{% tab title="2.0.0" %}
**Enhancements**

* Integration into YaK Core 2.1
* Support of PostgreSQL 16.7, 16.8, 17.3, 17.4
* Support of DMK 2.2.0
* Support of pgBackRest 2.54.1
* Support of etcd 3.5.19
* Automatic deployment of Azure Load Balancer and AWS Elastic Load Balancer
* Decommission of HA deployment
* New extensions available: PostGIS, TimescaleDB, pgvector

**Fixes**

* Fix wrong "max\_worker\_processes" value
* Fix wrong "wal\_compression" value
* Various minor fixes

**Mandatory Artifacts**

| Type                             | Storage path                                                                                            | Example                                                                    | Where to get it                                     |
| -------------------------------- | ------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------- | --------------------------------------------------- |
| PostgreSQL source code           | rdbms/postgresql/postgresql\_src/postgresql-x.y.tar.gz                                                  | rdbms/postgresql/postgresql\_src/postgresql-17.4.tar.gz                    | <https://www.postgresql.org/ftp/source/>            |
| PostgreSQL pre-compiled binaries | rdbms/postgresql/postgresql\_bin/\[Debian \| RedHat]/postgresql-x.y-\[Debian \| RedHat]\[x.y].tar.gz    | rdbms/postgresql/postgresql\_bin/RedHat/postgresql-17.4-RedHat9.5.tar.gz   | [Contact](https://yak4all.io/contact/) the YaK Team |
| etcd package                     | rdbms/postgresql/etcd/etcd-v3.5.19-linux-amd64.tar.gz                                                   | n/a                                                                        | <https://github.com/etcd-io/etcd/releases>          |
| DMK package                      | rrdbms/postgresql/dmk/dmk\_postgres-2.2.0.zip                                                           | n/a                                                                        | [Contact](https://yak4all.io/contact/) the YaK Team |
| pgBackRest source code           | rdbms/postgresql/pgbackrest\_src/pgbackrest-release-2.54.1.tar.gz                                       | n/a                                                                        | <https://github.com/pgbackrest/pgbackrest/releases> |
| pgBackRest pre-compiled binaries | rdbms/postgresql/pgbackrest\_bin/\[Debian \| RedHat]/pgbackrest-2.54.1-\[Debian \| RedHat]\[x.y].tar.gz | rdbms/postgresql/pgbackrest\_bin/RedHat/pgbackrest-2.54.1-RedHat9.5.tar.gz | [Contact](https://yak4all.io/contact/) the YaK Team |
| {% endtab %}                     |                                                                                                         |                                                                            |                                                     |

{% tab title="2.1.0" %}
**Enhancements**

* Support of PostgreSQL 16.9, 16.10, 17.5, 17.6
* Support of pgBackRest 2.56.0
* Support of etcd 3.6.4
* Support of minor and major upgrade of Patroni cluster
* Support of multiple Patroni clusters on the same hosts
* Optional Load Balancer deployment
* New extension available: pgAudit

**Fixes**

* Various minor fixes

**Mandatory Artifacts**

| Type                             | Storage path                                                                                            | Example                                                                    | Where to get it                                     |
| -------------------------------- | ------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------- | --------------------------------------------------- |
| PostgreSQL source code           | rdbms/postgresql/postgresql\_src/postgresql-x.y.tar.gz                                                  | rdbms/postgresql/postgresql\_src/postgresql-17.6.tar.gz                    | <https://www.postgresql.org/ftp/source/>            |
| PostgreSQL pre-compiled binaries | rdbms/postgresql/postgresql\_bin/\[Debian \| RedHat]/postgresql-x.y-\[Debian \| RedHat]\[x.y].tar.gz    | rdbms/postgresql/postgresql\_bin/RedHat/postgresql-17.6-RedHat9.5.tar.gz   | [Contact](https://yak4all.io/contact/) the YaK Team |
| etcd package                     | rdbms/postgresql/etcd/etcd-v3.6.4-linux-amd64.tar.gz                                                    | n/a                                                                        | <https://github.com/etcd-io/etcd/releases>          |
| DMK package                      | rrdbms/postgresql/dmk/dmk\_postgres-2.2.0.zip                                                           | n/a                                                                        | [Contact](https://yak4all.io/contact/) the YaK Team |
| pgBackRest source code           | rdbms/postgresql/pgbackrest\_src/pgbackrest-release-2.56.0.tar.gz                                       | n/a                                                                        | <https://github.com/pgbackrest/pgbackrest/releases> |
| pgBackRest pre-compiled binaries | rdbms/postgresql/pgbackrest\_bin/\[Debian \| RedHat]/pgbackrest-2.54.1-\[Debian \| RedHat]\[x.y].tar.gz | rdbms/postgresql/pgbackrest\_bin/RedHat/pgbackrest-2.56.0-RedHat9.5.tar.gz | [Contact](https://yak4all.io/contact/) the YaK Team |
| {% endtab %}                     |                                                                                                         |                                                                            |                                                     |
| {% endtabs %}                    |                                                                                                         |                                                                            |                                                     |