E.10. Postgres Pro Enterprise 14.9.2
Release Date: 2023-09-15
E.10.1. Overview
This release is based on Postgres Pro Enterprise 14.9.1 and provides the following changes:
Fixed two issues that could arise after upgrading Postgres Pro Enterprise using pg_upgrade. The first one resulted in incorrect conversion of multixacts from 32-bit to 64-bit transaction ID. Multixact values were erroneously incremented by 1 and files in
pg_multixact/membersandpg_multixact/offsetssubdirectories were misaligned in some cases, which manifested itself in “found multixact XXX from before relminmxid...” errors. The second issue caused incorrect HOT chain conversion from 32-bit to 64-bit and lead to the deletion of the intermediate tuples in HOT chain, yet did not affect data.Fixed race conditions during resource locking caused by an oversight in a recent optimization of the CFS garbage collector, which could result in data loss. One of the symptoms was leftover
pg_dependlinks referencing dropped temporary tables.Fixed a memory leak in mchar.
E.10.2. Migration to Version 14.9.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.
It is strongly recommended to avoid migrating a cluster with 32-bit transaction IDs to Postgres Pro Enterprise versions below 14.9.2, if there are multitransactions in your database, as it may cause data corruption.
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 14.