VMware Postgres v11.7 Release Notes

This document describes features, fixes, and known issues in VMware Postgres v11.7.

Software Component Versions

VMware Postgres Version Component Component Version
11.7.3 PostgreSQL 11.7
pgBackRest 2.23
Patroni 1.6.4
psqlODBC 11.00-0000
pgjdbc 42.2.9
PL/Java 1.5.5
PL/R 8.4 (R3.6.0)
PostGIS 2.5.4
11.7.2 PostgreSQL 11.7
pgBackRest 2.23
Patroni 1.6.4
psqlODBC 11.00-0000
pgjdbc 42.2.9
PL/Java 1.5.5
PL/R 8.4 (R3.6.0)
11.6.1 PostgreSQL 11.6
psqlODBC 11.00-0000
pgjdbc 42.2.5
pgBackRest 2.17
Patroni 1.5.6
11.5.5 PostgreSQL 11.5
psqlODBC 11.00-0000
pgjdbc 42.2.5
pgBackRest 2.17
Patroni 1.5.6
11.5.4 PostgreSQL 11.5
psqlODBC 11.00-0000
pgjdbc 42.2.5
pgBackRest 2.17
Patroni 1.5.6
11.5.3 PostgreSQL 11.5
psqlODBC 11.00-0000
pgjdbc 42.2.5
pgBackRest 2.17
Patroni 1.5.6
11.4.1 PostgreSQL 11.4
repmgr 4.2
psqlODBC 11.00-0000
pgjdbc 42.2.5
11.3.1 PostgreSQL 11.3
repmgr 4.2
psqlODBC 11.00-0000
pgjdbc 42.2.5
11.2.1 PostgreSQL 11.2
repmgr 4.2
psqlODBC 11.00-0000
pgjdbc 42.2.5
11.1.1 PostgreSQL 11.1
repmgr 4.2
psqlODBC 11.00-0000
pgjdbc 42.2.5

Release 11.7.3

Release Date: 2020-05-04

Features

PostGis

VMware Postgres 11.7.3 adds the Postgres PostGIS extension version 2.5.4 to the VMware Postgres extensions download file. See Installing the VMware Postgres Extensions for instructions to install the PostGIS extension.

PostgreSQL

  • VMware Postgres 11.7 updates the PostgreSQL database version to 11.7. Version 11.7 fixes an important security issue:

    • CVE-2020-1720: ALTER … DEPENDS ON EXTENSION is missing authorization checks.

  • PostgreSQL 11.7 includes numerous bug fixes and improvements, as highlighted in [https://www.postgresql.org/about/news/2011/). See E.1.2. Changes in the PostgreSQL 11.7 Release Notes for a complete list of changes.

  • VMware Postgres 11.7 now includes the PL/Java and PL/R procedural language extensions for Postgres. These extensions are packaged in a separately versioned download file. See Installing or Upgrading VMware Postgres for steps to download and install the extensions.

  • VMware Postgres 11.7 includes updated versions of pgBackRest, Patroni, and pgjdbc.

  • See Installing or Upgrading VMware Postgres for information about the RPM package contents and upgrade instructions.

Known Issues and Limitations

  • VMware does not support using the repmgr witness server, as it is not a full and complete solution for detecting split brain scenarios. Use external utilities (not provided by VMware) to prevent a split brain situation and to initiate fail-overs using the repmgr utilities.
  • VMware does not support using the deprecated XML2 module.
  • You cannot install VMware Postgres alongside an existing Red Hat Enterprise Linux PostgreSQL installation.
  • 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.