Release Date: 2023-09-14
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.
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.