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
inpg_temp
executes arbitrary SQL duringSECURITY DEFINER
executionCVE-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 Buildinguuid-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 therepmgr
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.