Release 15.6.1

Release Date: April 23, 2024

This topic describes the changes in VMware Postgres v15.6.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 15.6 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.1 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.7.0 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 15 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 15. 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 15.6.0

Release Date: February 15, 2024

This topic describes the changes in VMware Postgres v15.6.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 15.6 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.1 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.7.0 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 15 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 15.x

For upgrade details, see Upgrading VMware Postgres.

PostGIS customers on Postgres versions 10, 11, or 12 can only upgrade to Postgres 15.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.

Deprecated Features

  • The xml2 extension is included in VMware Postgres, but it is deprecated and unsupported.
check-circle-line exclamation-circle-line close-line
Scroll to top icon