E.33. Postgres Pro Enterprise 10.2.1

Release date: 2018-02-21

E.33.1. Overview

This release is based on PostgreSQL 10.2 and Postgres Pro Enterprise 10.1.1. All improvements inherited from PostgreSQL 10.2 are listed in PostgreSQL 10.2 Release Notes. As compared with Postgres Pro Enterprise 10.1.1, this version also provides the following changes:

  • Improved the multimaster extension:

    • Fixed GUC escaping rules.

    • Fixed a bug in replication protocol.

    • Fixed two-phase commit (2PC) decoding.

    • Corrected the behavior of the autonomous transactions when used in conjunction with the multimaster extension.

  • Fixed a bug in replication for B-tree indexes with the INCLUDE clause.

  • Replaced unsafe memcpy calls by strcpy in the pgpro_scheduler extension.

  • Fixed transaction callback handling in the in_memory extension.

  • Implemented dynamic prepare of the default directory for storing psql history on Windows systems.

  • Updated the pg_probackup utility to version 2.0.14.

    • Fixed race conditions in ptrack and page backups.

    • Fixed parallel ptrack backup interruption.

    • Added new backup state ORPHAN, which indicates that one of previous backups is corrupted.

  • Module pg_variables has been updated.

  • Updated pg_pathman module to version 1.4.9. This version fixes handling of ONLY in all kinds of queries. (See pg_pathman and Section F.40.1.1.)

  • Updated dump_stat module to version 1.1 that provides several bug fixes. (See dump_stat.)

  • Fixed incorrect handling of IS NULL and IS NOT NULL qual conditions in indexes with INCLUDE clauses.

  • Added int2vector compatibility patch.

  • Updated online-analyze module.

E.33.2. Migration to Version 10.2.1

If you are upgrading from a Postgres Pro Enterprise version based on the same PostgreSQL major release, it is enough to install the new version into your current installation directory.

To migrate from PostgreSQL, as well as Postgres Pro Standard or Postgres Pro Enterprise based on a previous PostgreSQL major version, see the migration instructions for version 10.