E.23. Postgres Pro Standard 10.3.2
Release Date: 2018-03-20
E.23.1. Overview
This release is based on PostgreSQL 10.3 and Postgres Pro Standard 10.3.1. All changes inherited from PostgreSQL 10.3 are listed in PostgreSQL 10.3 Release Notes. Other major changes and enhancements are as follows:
Added support for TOAST to INCLUDED attributes for B-tree indexes.
Fixed search for
mcharandmvarchartypes viasearch_path. These types can now be dumped even with the cleaned up search path.Added
--add-collprovideroption topg_dumpandpg_dumpallutilities.Updated the pg_probackup utility from version 2.0.14 to 2.0.16, which includes the following new features:
Fixed an infinite loop that could happen during page validation.
Fixed segfault for the case of parallel
PTRACKconnections.Allowed to use the
delete-waloption withoutdelete-expired.Schema name is now explicitly used in all function calls to address CVE-2018-1058 security issue.
Data files in the
globaldirectory are now handled properly: pg_probackup can now perform incremental backups and run checksum validation for such data files.PTRACKfiles from theglobaldirectory are not copied to backups anymore.pg_probackup now checks that the
--instanceoption is specified for theVALIDATEcommand.
Fixed an issue with sort ordering of some Russian letters in the
mcharmodule. UseREINDEX DATABASEcommand to update indexes.
E.23.2. Migration to Version 10.3.2
If you are upgrading from a Postgres Pro Standard version based on the same PostgreSQL major release, it is enough to install the new version into your current installation directory.
To migrate from PostgreSQL or a Postgres Pro Standard release based on a previous PostgreSQL major version, see the instructions in Postgres Pro Standard 10.1.1 Release Notes. If you are opting for a dump/restore, make sure to use the --add-collprovider option to correctly choose the provider for the default collation of the migrated database.