Release Date: 2023-11-16
This release is based on PostgreSQL 14.10 and Postgres Pro Standard 14.9.2. All improvements inherited from PostgreSQL 14.10 are listed in PostgreSQL 14.10 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.
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]).
Restricted the privileges of CREATEROLE and
its ability to modify other roles. Previously roles with
CREATEROLE privileges could change many
aspects of any non-superuser role. Such changes, including
adding members, now require the role requesting the change
to have ADMIN OPTION permission. For example,
they can now change the CREATEDB,
REPLICATION, and BYPASSRLS
properties only if they also have those permissions.
Added support for ALT SP Release 10.
Added support for Ubuntu 23.10.
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.
Fixed an internal issue that could arise when an index relation was moved to a different namespace similarly to a plain relation.
Upgraded oracle_fdw to version 2.6.0.
Upgraded orafce to version 4.6.1.
Upgraded pg_filedump to version 16.0.
Upgraded pgbouncer to version 1.20.1.
Upgraded pg_integrity_check, which now provides three new options.
Upgraded pg_proaudit to version 1.2, which provides the following changes:
Changed the name of the CONNECT events recorded
by pg_proaudit to AUTHENTICATE.
Removed the pg_proaudit.syslog_facility and
pg_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, the role_oid argument can
now be passed with NULL 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 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.
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.
When upgrading to Postgres Pro versions starting with 14.8.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 14.1.1 Release Notes.