## E.7. Postgres Pro 9.5.5.1

Release date: 2016-11-01

### E.7.1. Overview

This release is based on PostgreSQL 9.5.5

Major enhancements over Postgres Pro 9.5.4.1 include:

- Module pg_pathman has been updated to version 1.1.1 (See Section F.30, “pg_pathman”)

  Added pg_query_state module (See Section F.32, “pg_query_state”)

  Updates for pg_arman backup utility (See Section F.26, “pg_arman”)

  Fixes for covering indexes, correct work with more than 3-level indexes.

### E.7.2. Migration to Version 9.5.5.1

A dump/restore is not required for those running 9.5.4.1.

However, if you are upgrading from a version earlier than 9.5.4.1 or vanilla PostgreSQL 9.5.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 compiled Postgres Pro from source or create your database in non-default location, running `initdb` manually, you should run `pgpro_upgrade` script provided in this distribution.

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