E.1. Postgres Pro Enterprise 12.18.3
Release date: 2024-04-08
E.1.1. Overview
This release is based on Postgres Pro Enterprise 12.18.2 and provides the following changes:
Increased the maximum value of the
slru_buffers_size_scaleconfiguration parameter to 9. In some high-load environments, the former maximum value was not sufficient and could result in query queuing and locks.Fixed inconsistency of the
XMAXvalue and theXMAX_INVALIDhint bit of the tuple, which manifested itself in “missing chunk number 0 for toast value XXX in pg_toast_XXX” errors.Upgraded pgpro_pwr to version 4.5.
Upgraded pg_probackup to version 2.7.3 Enterprise, which provides optimizations and bug fixes. Notable changes are as follows:
Added the
--waldiroption to thecatchupcommand, which allows you to specify the directory to write WAL files to.Fixed incremental restore of tables larger than 1GB. Checksum computation for file pages was fixed, so the tables will no longer be reread from the backup during restore.
Fixed an abnormal termination of pg_probackup upon a forced termination of a backup.
Fixed slow validation and restore of large databases by fixing file comparison. Previously, the file sorting algorithm used for the comparison could result in quadratic complexity.
Fixed an issue that could occur during a backup in the root of an S3 bucket.
E.1.2. Migration to Version 12.18.3
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.