Release 14.11.1
Release Date: April 23, 2024
This topic describes the changes in VMware Postgres v14.11.1.
Software Component Versions
The following table lists the versions of PostgreSQL and the extensions included with this version of VMware Postgres. The table also links to the specific component documentation, as well as the release notes for the corresponding version of each extension.
| Type | Component | Version | Description |
|---|---|---|---|
| Core | PostgreSQL | 14.11 | The core database engine |
| High Availability | pgBackRest | 2.48 | Reliable backup and restore for PostgreSQL |
| pg_auto_failover | 2.1 | An extension for setting up PostgreSQL high availability with automated failover | |
| Patroni | 3.2.2 | A template for setting up PostgreSQL high availability with automated failover | |
| repmgr | 5.4.1 | A tool suite for managing replication and failover in a cluster of PostgreSQL servers | |
| Clients | psqlODBC | 16.00.0000 | Connectivity for Linux client applications |
| pgjdbc | 42.6.0 | Connectivity for Java applications | |
| Other | pgbouncer | 1.21.0 | A PostgreSQL connection pooler |
| PL/R | 8.4.6 | A loadable procedural language that enables you to write PostgreSQL functions and triggers in the R programming language | |
| Orafce | 4.9.1 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS | |
| PostGIS | 3.3.2 | A spatial database extension that improves the capabilities of the PostgreSQL relational database by adding support storing, indexing and querying geographic data | |
| pgAudit | 1.6.2 | Provides detailed session and/or object audit logging via the standard PostgreSQL logging facility | |
| PostgresML | 2.8.1 | Machine learning extension that enables you to perform training and inference on text and tabular data using SQL queries | |
| pgvector | 0.5.1 | Vector similarity search for PostgreSQL | |
| login_hook | 1.5 | Extension to execute some code on user login, comparable to Oracle’s after logon trigger | |
| pg_partman | 5.0.1 | Extension to make managing time or number/id based table partitioning easier |
VMware Postgres 14 additionally includes all of the contributed modules listed in Appendix F. Additional Supplied Modules of the PostgreSQL documentation.
Features and Changes
-
The JDBC driver for Tanzu Postgres is now available for Tanzu Postgres 14. Java programs can use the driver to connect to a PostgreSQL database using standard database-independent Java code.
For Red Hat Enterprise Linux (RHEL) versions 8 and 9, version 42.7.3 of the JDBC driver is now supported for VMware Postgres 12–16. For RHEL version 7, version 42.6.0 is supported.
- This release introduces the extension h3-pg, which adds PostgreSQL bindings for H3.
- This release introduces the extension pg_cron, a job scheduler.
- This release introduces the extension pg_stat_monitor for monitoring query performance.
- This release introduces the extension pg_failover_slots, which allows you to use logical replication slots across a physical failover in a physical streaming replication architecture.
- For Debian, this release adds a post-installation step that creates a default user account with permissions for the default database.
- This release introduces the advanced_password_check extension for checking passwords against password policies.
Release 14.11.0
Release Date: February 15, 2024
This topic describes the changes in VMware Postgres v14.11.0.
Supported Platforms
VMware Postgres is supported on Red Hat Enterprise Linux (RHEL) version 7, CentOS 7, RHEL version 8, RHEL version 9, and Ubuntu 22.04. 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.
IMPORTANT: For Red Hat Enterprise Linux 64-bit 8.x (RHEL8) deployments:
- Customers upgrading from RHEL7 to RHEL8 need to reindex all non-numeric indexes due to a change in glibc.
- RHEL8 supports Python 3. Existing PL/Python customers who upgrade from RHEL7 to RHEL8 need to verify all their existing Python functions with Python 3.
Software Component Versions
The following table lists the versions of PostgreSQL and the extensions included with this version of VMware Postgres. The table also links to the specific component documentation, as well as the release notes for the corresponding version of each extension.
| Type | Component | Version | Description |
|---|---|---|---|
| Core | PostgreSQL | 14.11 | The core database engine |
| High Availability | pgBackRest | 2.48 | Reliable backup and restore for PostgreSQL |
| pg_auto_failover | 2.1 | An extension for setting up PostgreSQL high availability with automated failover | |
| Patroni | 3.2.2 | A template for setting up PostgreSQL high availability with automated failover | |
| repmgr | 5.4.1 | A tool suite for managing replication and failover in a cluster of PostgreSQL servers | |
| Clients | psqlODBC | 16.00.0000 | Connectivity for Linux client applications |
| pgjdbc | 42.6.0 | Connectivity for Java applications | |
| Other | pgbouncer | 1.21.0 | A PostgreSQL connection pooler |
| PL/R | 8.4.6 | A loadable procedural language that enables you to write PostgreSQL functions and triggers in the R programming language | |
| Orafce | 4.9.1 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS | |
| PostGIS | 3.3.2 | A spatial database extension that improves the capabilities of the PostgreSQL relational database by adding support storing, indexing and querying geographic data | |
| pgAudit | 1.6.2 | Provides detailed session and/or object audit logging via the standard PostgreSQL logging facility | |
| PostgresML | 2.8.1 | Machine learning extension that enables you to perform training and inference on text and tabular data using SQL queries | |
| pgvector | 0.5.1 | Vector similarity search for PostgreSQL | |
| login_hook | 1.5 | Extension to execute some code on user login, comparable to Oracle’s after logon trigger | |
| pg_partman | 5.0.1 | Extension to make managing time or number/id based table partitioning easier |
VMware Postgres 14 additionally includes all of the contributed modules listed in Appendix F. Additional Supplied Modules of the PostgreSQL documentation.
Features and Changes
- This release introduces the extension pg_partman 5.0.1.
- The pgBackRest extension was upgraded from 2.48 to 2.50.
- The pg_auto_failover extension was upgraded from 2.0 to 2.1.
- The Patroni extension was upgraded from 3.2.0. to 3.2.2.
- The pgbouncer extension was upgraded from 1.20.1 to 1.21.0.
- The Orafce extension was upgraded from 4.7.0 to 4.9.1.
- The PostgresML extension was upgraded from 2.7.13 to 2.8.1.
- The pgvector extension was upgraded from 0.4.4 to 0.5.1.
- The login_hook extension was upgraded from 1.4 to 1.5.
Upgrading to VMware Postgres 14.x
For upgrade details, see Upgrading VMware Postgres.
PostGIS customers on Postgres versions 10, 11, or 12 can only upgrade to Postgres 14.x after they upgrade their existing Postgres to the latest minor version, and then upgrade PostGIS version to 3.X.
Known Issues and Limitations
- 773 - In an HA configuration, a failover scenario overwrites the files that reside in the data directory. Therefore keep important read-only files outside the configured data directory. Common read-only files include SSL certificates, keys, or different configuration files for primary and mirrors.
- Users of PostGIS on Postgres versions 10.x, 11.x, 12.x cannot upgrade to Postgres 14.11.0.
Deprecated Features
- The xml2 extension is included in VMware Postgres, but it is deprecated and unsupported.
