Pivotal Postgres v11.5 Release Notes

This document describes features, fixes, and known issues in Pivotal Postgres v11.5.

Software Component Versions

Pivotal Postgres Version Component Component Version
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 Date: 2020-01-22 (11.5.5)

Features

Pivotal Postgres 11.5 updates the PostgreSQL database version to 11.5. Version 11.5 fixes two important security issues:

  • CVE-2019-10208: TYPE in pg_temp executes arbitrary SQL during SECURITY DEFINER execution

  • CVE-2019-10209: Memory disclosure in cross-type comparison for hashed subplan

The pgBackRest backup and restore component has been added to this release.

The new high availability solution for Pivotal Postgres is Patroni. The repmgr component has been removed.

Version 11.5 also includes numerous bug fixes and improvements, as highlighted in https://www.postgresql.org/about/news/1960/. See E.1.2. Changes in the PostgreSQL 11.5 Release Notes for a complete list of changes.

Beginning with Pivotal Postgres 11.5.4, the Pivotal Postgres distribution includes the PostgreSQL modules listed in Appendix F. Additional Supplied Modules in the PostgreSQL documentation. The extensions can be installed into databases using the CREATE EXTENSION command.

  • Although the XML2 module is included, it is deprecated and is not supported by Pivotal.

  • Pivotal Postgres 11.11.4 includes all of the modules in Appendix F with the exception of the uuid-ossp module.

  • Pivotal Postgres 11.11.5 includes the uuid-ossp extension, compiled with --with-uuid=ossp, to use the OSSP UUID library. See Building uuid-ossp for information about the --with-uuid build configuration flag.

Upgrading to Pivotal Postgres 11.5

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

Known Issues and Limitations

  • Pivotal 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 Pivotal) to prevent a split brain situation and to initiate fail-overs using the repmgr utilities.
  • Pivotal does not support using the deprecated XML2 module.
  • You cannot install Pivotal 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.