E.28. Postgres Pro Standard

Release date: 2016-11-01

E.28.1. Overview

This release is based on PostgreSQL 9.6.1.

Major enhancements over Postgres Pro Standard include:

Added fix for pg_buffercache module, which improves database response in the case of connected monitoring tools.

Added new pgpro_edition() function, which returns a name of Postgres Pro edition, i.e. standard or enterprise.

E.28.2. Migration to Version

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

A dump/restore is not required for those running

However, if you are upgrading from vanilla 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 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.