E.9. Postgres Pro Standard 15.5.1
Release Date: 2023-11-24
E.9.1. Overview
This release is based onPostgreSQL 15.5 andPostgres Pro Standard 15.4.2. All improvements inherited fromPostgreSQL 15.5 are listed inPostgreSQL 15.5 Release Notes. Other major changes and enhancements are as follows:
Added new configuration parameterspgpro_build,pgpro_edition, andpgpro_version, which report thePostgres Pro source code commit ID, edition, and server version respectively.
Added thevacuum_update_datfrozenxid_only_when_needed configuration parameter to improve the performance when vacuuming a large number of tables.
ImplementedPostgres Pro-specificextensions to the SQL/JSON Path standard: sequence constructor, array constructor, object constructor and object subscription. They can be enabled by specifying an additional
pgpromodifier.Restricted the privileges of
CREATEROLEand its ability to modify other roles. Previously roles withCREATEROLEprivileges could change many aspects of any non-superuser role. Such changes, including adding members, now require the role requesting the change to haveADMIN OPTIONpermission. For example, they can now change theCREATEDB,REPLICATION, andBYPASSRLSproperties only if they also have those permissions.Added support for ALT SP Release 10.
Added support for Ubuntu 23.10.
Optimized memory consumption and time of performing a large number of expressions x=c_i (c_i are constants, i>= 500) joined by OR. The optimization is based on a replacement with ANY, such as replacement of x=1 OR x=2 OR x=3 with x=ANY([1,2,3]).
Fixed getting the version of the
libcdatabase default collation needed forpg_upgrade from older, Postgres Pro 10 — 14, clusters.Fixed an internal issue that could arise when an index relation was moved to a different namespace similarly to a plain relation.
Fixed too long planning that could take place when
JOINand index increased the number of variants to consider. Planning time was reduced by indexing equivalence classes and members of them.Upgradedoracle_fdw to version 2.6.0.
Upgradedorafce to version 4.6.1.
Upgradedpg_integrity_check, which now provides three new options.
Upgradedpg_filedump to version 16.0.
Upgradedpg_proaudit to version 1.2, which provides the following changes:
Changed the name of the
CONNECTevents recorded bypg_proaudittoAUTHENTICATE.Removed the
pg_proaudit.syslog_facilityandpg_proaudit.syslog_identconfiguration parameters. Instead, thesyslog_ident andsyslog_facility parameters can be used.Records in thesyslog are now marked with
AUDITfor clear identification.Added the
db_nameargument for functions that add and delete the logging settings. This argument allows specifying the name of the database for which security events need to be logged. Also, therole_oidargument can now be passed withNULLto enable logging actions for all users.
Upgradedpg_probackup to version 2.6.6, which in particular improved stability of the
catchupcommand.Upgradedpgbouncer to version 1.20.1.
Upgradedpgpro_controldata to version 16.1.0.
Upgradedpgpro_stats to version 1.6.3, which in particular fixed a code issue that prevented data generation for the
pgpro_stats_vacuum_tablesview. Accordingly the“Database vacuum statistics” table was not included in thepgpro_pwr report.UpgradedPTRACK to version 2.5.1 Enterprise.
Upgradedtds_fdw to version 2.0.3.
E.9.2. Migration to Version 15.5.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.
Starting fromPostgres Pro Standard 15.5.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 15.3.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 15.0.1 Release Notes.