## E.5. Postgres Pro Standard 10.2.1

Release Date: 2018-02-16

### E.5.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 Section F.40 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.5.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 Postgres Pro Standard versions based on any previous PostgreSQL major release, see the instructions in Postgres Pro Standard 10.1.1 Release Notes.