E.26. Postgres Pro Enterprise 10.5.3
Release date: 2018-10-11
E.26.1. Overview
This release is based on Postgres Pro Enterprise 10.5.2 and provides the following changes:
pgbadgernow supports the extended log format of Postgres Pro Enterprise. Its package got renamed topgpro-pgbadger.
Added a fix for incorrect calculation of the minimum recovery point on standby servers, which could cause incorrect page references.
Updated the online_analyze module, so that now it forbids nested
ANALYZEcalls.Increased the number of partitions of the shared buffer mapping hash table to 1024, which can improve performance on multi-core systems.
Fixed backup restore on a master server to avoid race conditions when applying two-phase transactions.
For Windows systems, fixed an issue with reloading dictionaries provided by the
shared_ispellmodule.Updated pg_probackup to version 2.0.21, which provides the following bug fixes:
Issues related to restoring backups taken on standbys are resolved.
The
log-rotation-sizeandlog-rotation-ageparameters are now parsed correctly.The
showcommand now dynamically changes width of the displayed output to improve readability for large tables.The
restorecommand now correctly restores all symbolic links to tablespaces.If checksums are enabled, the
validatecommand now verifies checksums for blocks.
E.26.2. Migration to Version 10.5.3
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.
Important
When upgrading from versions 10.3.3 or lower, you have to rebuild GiST indexes built over columns of the intarray type, as well as indexes that use mchar or mvarchar types.
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.