Release Date: 2018-03-20
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 mchar and mvarchar types via
search_path. These types can now be dumped even with
the cleaned up search path.
Added --add-collprovider option to
pg_dump and pg_dumpall utilities.
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 PTRACK connections.
Allowed to use the delete-wal option without delete-expired.
Schema name is now explicitly used in all function calls to address CVE-2018-1058 security issue.
Data files in the global directory
are now handled properly: pg_probackup
can now perform incremental backups and run checksum validation
for such data files.
PTRACK files from the global
directory are not copied to backups anymore.
pg_probackup now checks that the
--instance option is specified for the
VALIDATE command.
Fixed an issue with sort ordering of some Russian letters in the
mchar module.
Use REINDEX DATABASE command to update indexes.
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
Postgres Pro Standard versions based on
any previous PostgreSQL major release, 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 collation provider for the migrated database.