This document describes features, fixes, and known issues in VMware Postgres 11.18.
Release Date: November 14th, 2022
Supported Platforms
VMware Postgres is supported on Red Hat Enterprise Linux (RHEL) version 7, Red Hat Enterprise Linux (RHEL) version 8, and CentOS 7. This applies both to the core database software, as well as client components such as ODBC and JDBC.
Each RPM file included with VMware Postgres automatically installs additional operating-system package dependencies as needed. However, no Extra Packages for Enterprise Linux (EPEL) repository packages are required for VMware Postgres.
Network connectivity is required between all PostgreSQL hosts and clients.
ODBC support requires either the UnixODBC or iODBC driver manager on each client machine.
JDBC support requires Java 8 or higher on each client machine.
Software Component Versions
| VMware Postgres Version | Component | Component Version |
|---|---|---|
| 11.18.0 | PostgreSQL | 11.18 |
| pgBackRest | 2.41 | |
| pg_auto_failover | 2.0 | |
| pgbouncer | 1.17 | |
| Patroni | 2.1.4 | |
| Clients | psqlODBC | 13.02.0000 |
| pgjdbc | 42.4.1 | |
| Extensions | PL/Java | 1.5.8 |
| PL/R | 8.4.5 | |
| Orafce | 3.25.1 | |
| PostGIS | 2.5.8 with geos 3.8.1, proj 4.9.3, gdal 2.4.4 |
|
| PostGIS | 3.2.3 (RHEL 7) with geos 3.10.3, proj 8.2.1, gdal 3.4.3, psycopg2 2.9.1, SQLlite 3.30.1 |
|
| PostGIS | 3.2.3 (RHEL 8) with geos 3.10.3, proj 8.2.1, gdal 3.4.3, psycopg2 2.9.1 |
|
| pgAudit | 1.3.4 |
VMware Postgres 11 includes all of the contributed modules listed in Appendix F. Additional Supplied Modules of the PostgreSQL documentation.
Features
VMware Postgres 11.18.0 updates the PostgreSQL database version to 11.18.
For more details on the PostgreSQL 11.18 release, refer to E.1.2. Changes in the Release Notes.
This release updates pg_auto_failover to 2.0, and pgBackRest to version 2.41.
This release upgrades Orafce to version 3.25.1.
The pgjdbc client has been upgraded to version 42.5.
Upgrading to VMware Postgres 11.18.0
See Upgrading VMware Postgres for information about the RPM package contents and upgrade instructions.
To upgrade a VMware Postgres Patroni cluster minor version, see Upgrading VMware Postgres Minor Version in a Patroni Cluster.
Known Issues and Limitations
- 773 - A failover scenario causes files in the data directory to to be overwritten. Any files that you do not want overwritten should be stored outside the data directory. Such files include SSL certificates, keys, or different configuration files for primary and mirrors.
- VMware does not support using the deprecated XML2 module.
