E.1. Postgres Pro Enterprise 12.19.2
Release date: 2024-06-28
E.1.1. Overview
This release is based on Postgres Pro Enterprise 12.19.1 and provides the following changes:
Fixed two issues that could occur after upgrading from PostgreSQL or Postgres Pro Standard using pg_upgrade: fixed
xidbase calculation during heap page pruning andxmaxcalculation during page conversion from 32-bit to 64-bit format. These issues didn't result in data loss or corruption but raised PANIC-level errors.Fixed a segmentation fault caused by improper memory management in CFS, which could occur in some corner cases where CFS garbage collector was disabled or a standby server restored WAL records for a long time (e.g. it was lagging far behind).
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
JOINoperator.The enable_compound_index_stats configuration parameter was enabled.
The tables involved in the query had multi-column
INCLUDEindexes.
Upgraded orafce to version 4.10.3.
E.1.2. Migration to Version 12.19.2
If you are upgrading from a Postgres Pro Enterprise release based on the same PostgreSQL major version, 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 12.