E.13. Postgres Pro 9.5.9.1
Release date: 2017-09-01
E.13.1. Overview
This release is based onPostgreSQL 9.5.9 andPostgres Pro 9.5.8.1.
Major enhancements overPostgres Pro 9.5.8.1 include:
Updatedpg_pathman module to version 1.4.3. (SeeSection F.30 andSection F.30.1.1.) As compared to version 1.4.2, the following enhancements were introduced:
Disabled dangerous optimizations for
UPDATEandDELETEonPostgreSQL 9.5.Fixed the following type of query:
DELETE FROM single_table USING partitioned_table.Fixed the output of the
EXPLAIN INSERT INTO partitioned_tablecommand when verbose mode is activated.For a full list of changes, seepg_pathman Wiki.
E.13.2. Migration to Version 9.5.9.1
A dump/restore is not required for those running 9.5.8.1.
However, if you are upgrading from a version earlier than 9.5.x.x 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 a non-default location, runninginitdb manually, you should runpgpro_upgrade script provided in this distribution.
Before running the script, you should stop postgres service. Script should be run on behalf of the user owning the database (typically postgres) and PGDATA environment variable should be set to the directory where database resides.