VMware Postgres v11.9 Release Notes

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

Software Component Versions

VMware Postgres Version Component Component Version
11.9.2 PostgreSQL 11.9
pgBackRest 2.28
Patroni 1.6.5
psqlODBC 11.00-0000
pgjdbc 42.2.16
PL/Java 1.5.5
PL/R 8.4.1
PostGIS 2.5.5
Orafce 3.13.0
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.9.2

Release Date: 2020-09-18

Features

Orafce

VMware Postgres 11.9.2 includes the orafce 3.13.0 extension. orafce allows users to implement certain Oracle functions in PostgreSQL. See orafce for further information. See Installing the VMware Postgres Extensions for steps to download and install extensions.

PostgreSQL

  • VMware Postgres 11.9.2 updates the PostgreSQL database version to 11.9. Version 11.9 fixes two important issues:

    • CVE-2020-14349: Uncontrolled search path element in logical replication.
    • CVE-2020-14350: Uncontrolled search path element in CREATE EXTENSION.

    Version 11.9 also includes numerous bug fixes and improvements, as highlighted in E.1.2 Changes.

  • VMware Postgres 11.9.2 updates the PostGIS extension to 2.5.5, and the PL/R extension to 8.4.1. The extensions are packaged in a separately versioned download file. See Installing the VMware Postgres Extensions for steps to download and install the extensions.

  • VMware Postgres 11.9.2 updates pgjdbc to version 42.2.16.

  • 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.