E.16. Postgres Pro Standard 13.7.2

Release Date: 2022-06-08

E.16.1. Overview

This release is based on PostgreSQL 13.7 and Postgres Pro Standard 13.7.1. All improvements inherited from PostgreSQL 13.7 are listed in PostgreSQL 13.7 Release Notes. Other major changes and enhancements are as follows:

  • Changed the algorithm of composite type name generation. This fixes an issue in the code of vanilla PostgreSQL, which strictly limits the number of tables with the same long prefix in names.

  • Upgraded pg_probackup to version 2.5.6, which provides the following new features and bugfixes as compared to version 2.5.5:

    • Added the --dry-run flag to the catchup command to allow you to estimate the size of data files to be transferred, but make no changes on disk.

    • Changed the level of detail of logging some catchup messages for user convenience of log reading.

    • Fixed a bug that prevented correct rereading of a block after a message File: ... blknum ... have wrong checksum, try again was issued.

E.16.2. Migration to Version 13.7.2

If you are upgrading from Postgres Pro Standard based on the same PostgreSQL major version, it is enough to install the new version into your current installation directory.

When upgrading from Postgres Pro versions 13.2.1 or lower, rebuild indexes containing at least one included column of type for which the collation was defined in the table.

If you are upgrading from Postgres Pro versions 13.2.2 or lower and take PTRACK backups using pg_probackup, retake a full backup after upgrade.

To migrate from PostgreSQL or a Postgres Pro Standard release based on a previous PostgreSQL major version, see the instructions in Postgres Pro Standard 13.1.1 Release Notes.