E.4. Postgres Pro Standard 14.13.1
Release Date: 2024-08-15
E.4.1. Overview
This release is based onPostgreSQL 14.13 andPostgres Pro Standard 14.12.2. All improvements inherited fromPostgreSQL 14.13 are listed inPostgreSQL 14.13 Release Notes. Other major changes and enhancements are as follows:
Enhanced performance of segment search by implementing a new search strategy, allowing faster detection of the last segment.
Implemented the interaction of thePASSWORD_GRACE_TIME profile parameter with the
VALID UNTILrole attribute. Now if both of them are set, the warning about password expiration will be displayed.Prevented potential authentication delays due to locking by not updating role's last login time if the role's profile
USER_INACTIVE_TIMEis set to unlimited (seeSection 51.39 for details).Fixed a bug that caused the optimizer to ignore columns from query conditions. Previously, when partially using a composite index, the number of rows could be overestimated, which led to an incorrect plan creation. The bug occurred due to a malfunction of the multi-column statistics elements.
Fixed a bug in
ANALYZEthat could occur because it was impossible to display thepg_statisticsystem catalog. For the fix to work, if your database has indexes withINCLUDEcolumns, after upgradingPostgres Pro, it is recommended to do anotherANALYZEfor these columns.Added support for ALT 11.
Ended support for Ubuntu 23.04.
Upgraded themchar extension to fix a bug that caused the
mcharandmvarchardata types to ignore control characters during string comparison.Upgradedpg_proaudit to provide the following optimizations and bug fixes:
Improved performance and added the
pg_proaudit.max_rules_countparameter, which allows specifying the maximum number of rules allowed.Corrected support of database names including uppercase symbols by the
pg_proaudit_set_rulefunction.
Upgradedpg_probackup to version 2.8.3, which fixes backup validation for databases containing an OID larger than 109. Previously, the validation status could be displayed incorrectly in such cases.
Upgradedpg_filedump to version 17.0, which provides optimizations and bug fixes. In particular, contents of meta pages for GIN and SP-GiST indexes are now displayed correctly, and an issue of lacking memory for encoding and decompression is resolved.
Fixed incorrect behavior ofpg_wait_sampling when used with the extended query protocol.
E.4.2. Migration to Version 14.13.1
If you are upgrading fromPostgres Pro Standard based on the samePostgreSQL major version, it is enough to install the new version into your current installation directory.
If you take backups usingpg_probackup and you have previously upgraded it to version 2.8.0 or 2.8.1, make sure to upgrade it to version 2.8.2 or higher and retake a full backup after upgrade, since backups taken using those versions might be corrupted. If you suspect that your backups taken with versions 2.8.0 or 2.8.1 may be corrupted, you can validate them using version 2.8.2.
Starting fromPostgres Pro Standard 14.10.1, the privileges ofCREATEROLE are restricted, and modification of other roles requires the role requesting the change to have theADMIN OPTION permission.
When upgrading toPostgres Pro versions starting with 14.8.1, make sure to upgradepg_probackup to version 2.6.3 or higher since lower versions are incompatible with thesePostgres Pro versions.
To migrate fromPostgreSQL or aPostgres Pro Standard release based on a previousPostgreSQL major version, see the instructions inPostgres Pro Standard 14.1.1 Release Notes.