E.25. Postgres Pro Standard 9.6.4.1
Release date: 2017-08-14
E.25.1. Overview
This release is based onPostgres Pro Standard9.6.3.3 andPostgreSQL9.6.4.
Major enhancements overPostgres Pro Standard 9.6.3.3 include:
Fixed an incorrect catalog check in
pg_dumpthat has been added with the previous release.Added distribution for Ubuntu 17.10.
E.25.2. Migration to Version 9.6.4.1
A dump/restore usingpg_dumpall, or use ofpg_upgrade, is required for those wishing to migrate data from any previous major release.
A dump/restore is required for those running 9.6.3.3, because catalog number format has been changed for betterPostgres Pro identification.
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 compiledPostgres 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.