Release 13.14.1
Release Date: April 23, 2024
This topic describes the changes in VMware Postgres v13.14.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 | 13.14 | The core database engine |
| High Availability | pgBackRest | 2.50 | 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.5.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 | 4.7.4 | Extension to make managing time or number/id based table partitioning easier |
VMware Postgres 13 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 13. 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 13.14.0
Release Date: February 15, 2024
This topic describes the changes in VMware Postgres v13.14.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.
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 | 13.14 | The core database engine |
| High Availability | pgBackRest | 2.50 | 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.5.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 | 4.7.4 | Extension to make managing time or number/id based table partitioning easier |
VMware Postgres 13 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 4.7.4.
- 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 13.x
For upgrade details, see Upgrading VMware Postgres.
PostGIS customers on Postgres versions 10, 11, or 12 can only upgrade to Postgres 13.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 - Because a failover scenario requires files in the data directory to to be overwritten, you should store all read-only files outside of the configured data directory. Common read-only files include SSL certificates, keys, or different configuration files for primary and mirrors.
Deprecated Features
- The xml2 extension is included in VMware Postgres, but it is deprecated and unsupported.
