E.3. Postgres Pro Standard 15.7.2

Release Date: 2024-06-27

E.3.1. Overview

This release is based on Postgres Pro Standard 15.7.1 and provides the following changes:

  • Fixed a bug in the backend composite type cache management. This bug could result in a segmentation fault or produce errors like ERROR: record type has not been registered during the process of selectivity estimation in query planning under the following conditions:

    • The query contained at least one JOIN operator.

    • The enable_compound_index_stats configuration parameter was enabled.

    • The tables involved in the query had multi-column INCLUDE indexes.

  • Upgraded orafce to version 4.10.3.

  • Upgraded pg_probackup to version 2.8.2, which provides the following bug fixes:

    • Fixed an OID parsing issue where databases and tablespaces with relfilenodes greater than a billion were not included in backups.

    • Fixed an issue in enabling pg_probackup logging with the --log-level-file parameter, where the parameter value was written to the configuration file, but no directory for log files was created.

E.3.2. Migration to Version 15.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.

Important

If you take backups using pg_probackup and you have previously upgraded it to version 2.8.0 or 2.8.1, make sure to upgrade it to version 2.8.2 or higher and retake a full backup after upgrade, since backups taken using those versions might be corrupted. If you suspect that your backups taken with versions 2.8.0 or 2.8.1 may be corrupted, you can validate them using version 2.8.2.

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