Fixed an issue where multimaster returned an error when executing read-write transactions containing queries to postgres_fdw foreign tables. The root cause was that postgres_fdw does not support two-phase commit transactions used by multimaster. To fix the issue, the postgres_fdw.read_only_transactions configuration parameter was implemented. When set to on, it enables read-only queries to foreign tables in read-write transactions, which allows seamless operation of multimaster and postgres_fdw.

Fixed an issue of potential transaction commit latency caused by an error in the exchange logic for messages containing information about transaction application on nodes.

Added support for logging of the following event types: ANALYZE, DISCARD ALL, DISCARD PLANS, DISCARD SEQUENCES, DISCARD TEMP (for temporary tables), CHECKPOINT, FETCH, and MOVE.

Added the new event class MISC. This class allows logging of all events (including those mentioned above) not related to other event classes.

Added a new method for logging security events. Events in CEF format can now be logged not only in a separate file but also in syslog.

Added a new event log field: application name. AUTHENTICATE events now contain the name of the initiating application alongside the connection parameters.

Fixed an issue with pg_proaudit failing to log security events in a CEF file.

Fixed an issue with pg_proaudit failing to log events for the INSERT command following CREATE within anonymous code blocks (the DO command) and stored procedures/functions.

Fixed an issue with pg_proaudit overloading a CPU core due to failed log rotation.

Added support for Postgres Pro Enterprise 18.

Added support for Transparent Data Encryption (TDE). The version output of pg_probackup now displays a TDE support indicator.

Made the host from which a backup was taken to be saved in backup.control and displayed in the show command output.

Improved the behavior during restore from read-only media, including more informative warning messages.

For archive-push and archive-get operations in the remote mode, made SIGQUIT signals to be ignored to prevent core dumps of helper programs when the server stops.

Added validation to ensure consistency between the port number in PGDATA and the --pgport option. Also added the --force flag to perform backups even when these values mismatch.

Fixed handling of external tablespaces during incremental restore. When using the --force flag, the tablespace contents are no longer overwritten.

Fixed a problem with the backup command holding the replication slot after successful completion.

Fixed the identifier conflict for the --wal-tree option by adding a uniqueness test.

Fixed the order of displaying the calculated and expected checksum values in the warning message.

Improved take_sample time tracking.

Added support of pgpro_stats 1.10.

Added a possibility to exclude server connection strings from dumps.

Added statistics on restartpoints to the reports when it is available.

Added new statistics to pgpro_stats_statements and pgpro_stats_totals views. These statistics were added to pg_stats_statements in Postgres Pro 18. Related functions are updated accordingly.

Added the new pgpro_stats_statements_filtered function to filter statistics similar to those provided in the pgpro_stats_statements view by one or several fields: userid, dbid, queryid, and planid. Calling this function is faster than querying the pgpro_stats_statements view with appropriate values of these fields.

Improved the behavior of pgpro_stats similarly to pg_stat_statements. The changes are:

Fixed an issue that could occur when in pgpro_stats custom metrics were changed on the fly. Now any change to custom metrics requires a server restart.