E.31. Postgres Pro Enterprise 10.3.2

Release date: 2018-03-20

E.31.1. Overview

This release is based on Postgres Pro Enterprise 10.3.1 and provides the following changes:

  • Added multimaster support to pgpro_scheduler extension.

  • 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.

E.31.2. Migration to Version 10.3.2

If you are upgrading from a Postgres Pro Enterprise 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, as well as Postgres Pro Standard or Postgres Pro Enterprise based on a previous PostgreSQL major version, see the migration instructions for version 10. 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.