E.2. Postgres Pro Enterprise 10.6.2

E.2.1. Overview
E.2.2. Migration to Version 10.6.2

Release date: 2019-01-10

E.2.1. Overview

This release is based on Postgres Pro Enterprise 10.6.1. As compared with Postgres Pro Enterprise 10.6.1, this version provides the following changes:

  • Fixed handling of transaction statements in the prepared statement LRU cache.

  • Fixed several problems in autonomous transaction support. Now nested autonomous transactions work correctly, and access to PL/pgSQL variables from outer context is allowed from inside an autonomous block.

  • Fixed handling of table rows with columns of extended storage class (such as geometry in PostGIS) if the size of such rows is very close to page size.

  • Updated pg_probackup module to version 2.0.26, which provides multiple bug fixes and improvements. For a full list of changes, see pg_probackup Wiki.

E.2.2. Migration to Version 10.6.2

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.

Important

When upgrading from versions 10.3.3 or lower, you must execute the REINDEX command for GiST and SP-GiST indexes, as well as indexes that use mchar or mvarchar types.

To migrate from PostgreSQL, Postgres Pro Standard, or Postgres Pro Enterprise versions based on any previous PostgreSQL major release, see the instructions in Postgres Pro Enterprise 10.1.1 Release Notes. If you are opting for a dump/restore, make sure to use the --add-collprovider option to correctly choose the collation provider for the migrated database.