VMware Postgres v14.7 Release Notes

Release 14.7.0

Release Date: February 17th, 2023

This topic describes the changes in VMware Postgres v14.7.0.

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.

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

VMware Postgres Version	Component	Component Version
14.7.0	PostgreSQL	14.7
	pgBackRest	2.44
	pg_auto_failover	2.0
	pgbouncer	1.18
	Patroni	3.0
Clients	psqlODBC	13.02.0000
	pgjdbc	42.5.3
Extensions	PL/Java	1.5.8 (Deprecated)
	PL/R	8.4.5
	Orafce	4.1.1
	PostGIS	3.3.2 (RHEL 7) with geos 3.10.3, proj 8.2.1, gdal 3.4.3, SQLlite 3.30.1
	PostGIS	3.3.2 (RHEL 8) with geos 3.10.3, proj 8.2.1, gdal 3.4.3
	pgAudit	1.6.2

VMware Postgres 14 includes all of the contributed modules listed in Appendix F. Additional Supplied Modules of the PostgreSQL documentation.

Features

• VMware Postgres 14.7.0 updates the PostgreSQL database version to 14.7. Postgres 14.7 resolves the following CVE:

  • (CVE-2022-41862) Client memory disclosure when connecting, with Kerberos, to modified server

  For more details on the PostgreSQL 14.7 release, refer to E.1.2. Changes in the Release Notes.

• This release updates pgBackRest to version 2.44, pgbouncer to 1.18, and Patroni to 3.0.

  Note

  Although Patroni 3.0 introduces support for Citus, VMware Postgres does not support Citus.

• This release upgrades Orafce to version 4.1.1.
• The pgjdbc client has been upgraded to version 42.5.3.
• The Orafce extension was upgraded to version 4.1.1.
• PL/Java 1.5.8 is deprecated, and the extension will not be provided in future releases.
• PostGIS was upgraded to version 3.3.2. In order to upgrade an existing PostGIS installation:
  1. Run the following commands:

     ALTER EXTENSION postgis UPDATE TO "3.3.2";
     SELECT postgis_extensions_upgrade();
     

  2. Verify that the extension was upgraded:

     SELECT postgis_full_version();
     

Upgrading to VMware Postgres 14.7

For upgrade details, see Upgrading VMware Postgres.

PostGIS customers on Postgres versions 10, 11, or 12 can only upgrade to Postgres 14.7 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.7.0.
• VMware does not support using the deprecated XML2 module.
• All software components in this release, including the client ODBC and JDBC drivers, are supported only on Red Hat Enterprise Linux (RHEL) version 7, and CentOS 7 systems.

• The xml2 extension is included in VMware Postgres, but it is deprecated and unsupported.