E.6. Postgres Pro Standard 15.5.1
Release Date: 2023-11-24
E.6.1. Overview
This release is based on PostgreSQL 15.5 and Postgres Pro Standard 15.4.2. All improvements inherited from PostgreSQL 15.5 are listed in PostgreSQL 15.5 Release Notes. Other major changes and enhancements are as follows:
Added new configuration parameters pgpro_build, pgpro_edition, and pgpro_version, which report the Postgres Pro source code commit ID, edition, and server version respectively.
Added the vacuum_update_datfrozenxid_only_when_needed configuration parameter to improve the performance when vacuuming a large number of tables.
Implemented Postgres Pro-specific extensions to the SQL/JSON Path standard: sequence constructor, array constructor, object constructor and object subscription. They can be enabled by specifying an additional
pgpro
modifier.Restricted the privileges of
CREATEROLE
and its ability to modify other roles. Previously roles withCREATEROLE
privileges could change many aspects of any non-superuser role. Such changes, including adding members, now require the role requesting the change to haveADMIN OPTION
permission. For example, they can now change theCREATEDB
,REPLICATION
, andBYPASSRLS
properties 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
libc
database default collation needed for pg_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
JOIN
and index increased the number of variants to consider. Planning time was reduced by indexing equivalence classes and members of them.Upgraded oracle_fdw to version 2.6.0.
Upgraded orafce to version 4.6.1.
Upgraded pg_integrity_check, which now provides three new options.
Upgraded pg_filedump to version 16.0.
Upgraded pg_proaudit to version 1.2, which provides the following changes:
Changed the name of the
CONNECT
events recorded bypg_proaudit
toAUTHENTICATE
.Removed the
pg_proaudit.syslog_facility
andpg_proaudit.syslog_ident
configuration parameters. Instead, the syslog_ident and syslog_facility parameters can be used.Records in the syslog are now marked with
AUDIT
for clear identification.Added the
db_name
argument 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_oid
argument can now be passed withNULL
to enable logging actions for all users.
Upgraded pg_probackup to version 2.6.6, which in particular improved stability of the
catchup
command.Upgraded pgbouncer to version 1.20.1.
Upgraded pgpro_controldata to version 16.1.0.
Upgraded pgpro_stats to version 1.6.3, which in particular fixed a code issue that prevented data generation for the
pgpro_stats_vacuum_tables
view. Accordingly the “Database vacuum statistics” table was not included in the pgpro_pwr report.Upgraded PTRACK to version 2.5.1 Enterprise.
Upgraded tds_fdw to version 2.0.3.
E.6.2. Migration to Version 15.5.1
If you are upgrading from Postgres Pro Standard based on the same PostgreSQL major version, it is enough to install the new version into your current installation directory.
Starting from Postgres Pro Standard 15.5.1, the privileges of CREATEROLE
are restricted, and modification of other roles requires the role requesting the change to have the ADMIN OPTION
permission.
When upgrading to Postgres Pro versions starting with 15.3.1, make sure to upgrade pg_probackup to version 2.6.3 or higher since lower versions are incompatible with these Postgres Pro versions.
To migrate from PostgreSQL or a Postgres Pro Standard release based on a previous PostgreSQL major version, see the instructions in Postgres Pro Standard 15.0.1 Release Notes.