E.1. Postgres Pro Standard 16.15.1 #
Date: 2026-08-31
E.1.1. Overview #
This release is based on PostgreSQL 16.15 and Postgres Pro Standard 16.14.1. All improvements inherited from PostgreSQL 16.15 are listed in PostgreSQL 16.15 Release Notes. Other major changes and enhancements are as follows:
Added the wal_sender_shutdown_timeout server variable to limit replica synchronization waits during shutdown. By default, senders still wait forever for synchronization.
Reworked the
pg_stats_vacuum_tables,pg_stats_vacuum_indexes, andpg_stats_vacuum_databasefunctions that provide vacuum statistics. Previously, these functions could returnNULLinstead of an empty result set when no statistics were found for the specified relation or database. Also fixed incorrect inclusion of cluster-wide relation statistics in per-database queries, and added error reporting for invalid input arguments.Returned the vanilla implementation of the hba_file configuration parameter, as the previous fix interfered with Patroni and caused server startup failures.
Fixed recovery failures caused by missing intermediate relation segments in backups taken with pg_basebackup. Gaps between the segments are now detected and filled during the recovery process.
Inherited the PostgreSQL fix that prevents truncation of CLOG that is still needed by unread
NOTIFYmessages. This fix prevents “could not access status of transaction” errors when a backend is slow to absorbNOTIFYmessages.Updated aqo to provide the following enhancements and bug fixes:
Simplified the steps to enable aqo. Now you do not need to execute the
CREATE EXTENSIONcommand for aqo operation. This command is required only for using aqo functions and views.Fixed an issue with statistics collection in the
intelligentmode, which caused incorrect aqo learning.
Upgraded the hypopg extension to version 1.4.3.
Upgraded mamonsu to version 3.5.17.
Upgraded the ODBC driver to version 18.00.0002.
Upgraded orafce to version 4.16.7.
Upgraded the pgbouncer_exporter utility to version 0.12.1.
Upgraded pg_proaudit to version 2.1 to provide the following enhancements and bug fixes:
Added the
exclude_role_nameparameter to thepg_proaudit_set_rule(),pg_proaudit_remove_rule(), andpg_proaudit_reload()functions, which allows excluding specific roles from logging. This is useful for filtering out actions of technical roles that would otherwise make the audit log overly verbose.Added the
pg_proaudit.csv_split_messagesconfiguration parameter that controls whether security events in CSV and syslog output are written as a single line or multiple lines. When disabled, each security event is written on a single line, which simplifies log analysis and parsing.Fixed an issue with unreadable characters in CSV, CEF, and syslog log entries when using a database with a non-UTF-8 encoding. All string fields in the log output are now converted to UTF-8 regardless of the database encoding.
Upgraded pg_probackup to version 2.8.15 to provide the following improvements and bug fixes:
Added multithreading support for the
deletecommand via thej/--threadsoption. Backup deletion according to the retention policy and WAL archive cleanup are now executed in parallel.Fixed infinite looping on corrupted backups by adding loop detection. ID order is now validated when reading the backup catalog or searching for the parent full backup.
Optimized Postgres Pro port validation. Instead of reading from
postgresql.confandpostgresql.auto.conf, which may contain outdated information, the port is now read from thepostmaster.pidfile of the running server. If the instance port does not match the configuration, pg_probackup issues a warning.Fixed the
checkdbandcatchupcommand termination that could occur when an instance was specified without setting the backup catalog path via the-B/--backup-pathor theBACKUP_PATHenvironment variable. Now a clear error message is displayed.Improved diagnostics of remote connection errors. Previously, specifying an incorrect port that was already in use would cause the process to terminate without an error. Now, the reason for termination is displayed, along with a recommendation to check connection parameters.
Fixed a memory leak that could occur when reading the server configuration files.
Eliminated a potential null pointer dereference by adding out-of-memory handling when parsing the recovery target name in WAL.
Added the
--write-rate-limitoption to thecatchupcommand help output. In other command descriptions, this option's argument,baudrate, is renamed tobitrate.
Updated the pgpro_bindump module to include the following bug fixes:
Fixed an issue with parallel backups. Previously, each backup created a replication slot with the same default name, causing parallel backups to conflict and terminate with an error.
Fixed backup failures that occurred if a file disappeared between scanning a directory and attempting to access it, for example, if it was deleted by Postgres Pro.
Fixed an issue with
PTRACKbackups. Previously, an error would occur ifptrackwas not added toshared_preload_librarieswhileptrack.map_sizewas set to non-zero.Fixed an issue that manifested as a “could not stat file” error and could cause backup or restore processes to crash. Temporary files created by the CFS garbage collector are now skipped during these operations.
Fixed an issue where the
--external-dirsoption failed to process symbolic links correctly, causing the operation to fail with an error.
Upgraded pgpro_pwr to version 4.15, which provides enhancements and bug fixes. Notable changes are as follows:
Added support for statistics of the PostgreSQL 19 core.
Added support for pg_stat_statements 1.13.
Added support for pg_stat_kcache 2.3.2.
Added new report sections and fields.
Fixed the missing integrity constraint, which prevented the cascade deletion of subsample data due to retention policy and thus caused remaining of now-redundant rows in the session statistics table.
Upgraded the pgpro_scout utility to version 1.0.4.
Upgraded pgpro_stats to version 1.11 to provide the following enhancements and bug fixes:
Added the
pgpro_stats.enable_warningsconfiguration parameter that adds a warning to theplanfield of thepgpro_stats_statementsview if the plan was executed with partition pruning.Fixed a plan normalization issue that could be observed for queries executed using the
EXPLAIN EXECUTEcommand by adding a hook for saving information needed for the plan normalization. As a result, sensitive information is no longer exposed in query plans displayed in pgpro_stats views and pgpro_pwr reports.
Upgraded pgpro_validate to version 1.2.0 to include the following bug fixes:
Fixed SQL injection vulnerabilities in query generation.
Fixed a quoting issue that led to “relation does not exist” errors when running the
molotilkacommand on tables in schemas whose names contain uppercase or special characters.Fixed false “no matching entry in pg_attribute table” warnings for
pg_shdependrows whose objects belong to other databases of the cluster.
Upgraded pgvector to version 0.8.5.
Upgraded pg_wait_sampling to version 1.1.1 to extend its wait event statistics functionality, previously available only in pgpro_stats, and to provide the following enhancements and bug fixes:
Added the
pg_wait_sampling.history_dimensionsandpg_wait_sampling.profile_dimensionsconfiguration parameters that allow you to customize the set of dimensions recorded in the history and the profile.Extended the
pg_wait_sampling_current,pg_wait_sampling_history, andpg_wait_sampling_profileviews with additional wait event dimensions.Added the
pg_wait_sampling_statementsview that provides wait event statistics grouped by query and plan identifiers.Added the
pg_wait_sampling_objectsview that provides wait event statistics for configurable dimensions, such as database, user, client address, application, backend, or session.Fixed an issue that caused queries to
pg_wait_sampling_profileto hang when the collector process stopped. Hung queries could not be cancelled normally, and the cluster required an emergency restart. The collector now restarts automatically, and queries return an error when the collector is unavailable.Fixed handling of the
pg_wait_sampling.profile_periodconfiguration parameter, which was previously ignored in the collector's timing calculation. Sampling interval accuracy has also been improved.
Updated rum to fix a crash that could occur during a RUM index scan if a concurrent
VACUUMremoved all items from a posting tree leaf page.
E.1.2. Migration to Version 16.15.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.
If you used a previous version of aqo and need to upgrade it, after the upgrade of the primary server, the standby servers may have a different aqo version.
To avoid any related issues, disable aqo by setting aqo.enable and aqo.wal_rw to off first on the primary server and then on the standby servers. After the upgrade completes successfully, re-enable aqo by setting aqo.wal_rw and aqo.enable to on first on the standby servers and then on the primary server.
ABI versions may change between minor releases of Postgres Pro. If this is the case, and you see the ABI mismatch error when trying to run your extension, make sure to install a new version of the extension supplied with a new release of Postgres Pro, or recompile your third-party extension to be able to use it with the current version of Postgres Pro.
If you take backups using pg_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.
To migrate from PostgreSQL or a Postgres Pro Standard release based on a previous PostgreSQL major version, see the instructions in Postgres Pro Standard 16.0.1 Release Notes.