E.25. Postgres Pro Standard 10.2.1

Release Date: 2018-02-16

E.25.1. Overview

This release is based on PostgreSQL 10.2 and includes all the new features introduced in PostgreSQL 10, as well as bug fixes implemented in PostgreSQL 10.2. For their detailed description, see PostgreSQL 10 Release Notes and PostgreSQL 10.2 Release Notes, respectively. Other major changes and enhancements are as follows:

  • 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.36.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.25.2. Migration to Version 10.2.1

If you are upgrading from a Postgres Pro Standard 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 or a Postgres Pro Standard release based on a previous PostgreSQL major version, see the instructions in Postgres Pro Standard 10.1.1 Release Notes.