E.6. Postgres Pro Enterprise 13.12.2

Release Date: 2023-09-14

E.6.1. Overview

This release is based on Postgres Pro Enterprise 13.12.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/members and pg_multixact/offsets subdirectories 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_depend links referencing dropped temporary tables.

  • Fixed a memory leak in mchar.

E.6.2. Migration to Version 13.12.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 13.12.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 13.