E.1. Postgres Pro Standard 15.19.1
Date: 2026-08-27
E.1.1. Overview
This release is based on PostgreSQL 15.19 and Postgres Pro Standard 15.18.1. All improvements inherited from PostgreSQL 15.19 are listed in PostgreSQL 15.19 Release Notes. Other major changes and enhancements are as follows:
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.
Fixed an issue that could cause the pg_pathman extension with the enabled
pg_pathman.enable_partitionrouterparameter to fail when trying to execute theUPDATE ... FROMcommand using common table expressions.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 fix an issue with statistics collection in the
intelligentmode, which caused incorrect aqo learning.Upgraded mamonsu to version 3.5.17.
Upgraded the ODBC driver to version 18.00.0002.
Upgraded orafce to version 4.16.7.
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 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 15.19.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.
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.
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.