## E.25. Postgres Pro Enterprise 9.6.3.1

Release date: 2017-05-25

### E.25.1. Overview

This release is based on Postgres Pro Enterprise 9.6.2.1 and Postgres Pro Standard 9.6.3.1.

Major enhancements over Postgres Pro Enterprise 9.6.2.1 include:

- Updated the pg_probackup backup manager to version 1.1.11. Command-line interface has been changed.

- Improved multimaster extension:

  - Added support for savepoints.

  - Extended support for DDL statements.

  (See Section F.32.)

- Enabled support for multiple data types in RUM index, such as `int`, `bigint`, `float`, `time`, `interval`, `bytea`, `text`, and more. You can now store `tsvector` type together with other types in a single index.

  (See Section F.57.)

- Improved autonomous transaction support:

  - Fixed handling of multixact IDs.

  - Speeded up execution of autonomous transactions.

  (See Chapter 16.)

### E.25.2. Migration to Version 9.6.3.1

A dump/restore using pg_dumpall, or use of pg_upgrade, is required for those wishing to migrate data from any previous major release.

Dump/restore is necessary when migrating from PostgreSQL, Postgres Pro Standard, or Postgres Pro Enterprise edition.

For upgrades from previous releases of Postgres Pro Enterprise, Postgres Pro Standard, or PostgreSQL 9.6.x, some catalog changes should be applied.

If you use binary packages, and your database is in the default location, this upgrade should be performed automatically. If you've created your database in a non-default location, running `initdb` manually, you should run the `pgpro_upgrade` script provided in this distribution.

Before running the script, you should stop the `postgres` service. The script should be run on behalf of the user owning the database (typically `postgres`), and the `PGDATA` environment variable should be set to the directory where the database resides.