E.25. Postgres Pro Standard 188.8.131.52
Release date: 2017-05-15
Major enhancements over Postgres Pro Standard 184.108.40.206 include:
Added pg_tsparser extension for text search.
In addition to separate word parts returned by default, pg_tsparser also returns the whole word if this word includes:
numbers and letters separated by the hyphen character
Updated the pg_pathman module to version 1.3.2. This version provides compatibility fixes for this release.
The sr_plan module is now working with non-default
Fixed WAL inconsistency bug in covering indexes.
Added distribution for SUSE Linux Enterprise Server 12 SP1 and Ubuntu 17.04.
Applied patches to optimize inheritance.
Updated PTRACK patch to version 1.2.
Provided performance improvements for queries typical for 1C solutions.
E.25.2. Migration to Version 220.127.116.11
A dump/restore is not required for those running 18.104.22.168.
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 a non-default location, running
initdb manually, you should run
pgpro_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.