E.1. Postgres Pro Standard 18.1.1 #
Release Date: 2025-12-08
E.1.1. Overview #
This release is based on PostgreSQL 18.1 and Postgres Pro Standard 18.0.1. All improvements inherited from PostgreSQL 18.1 are listed in PostgreSQL 18.1 Release Notes. Other major changes and enhancements are as follows:
Improved the search mechanism for matching
mcharandmvarcharstrings using theLIKEoperator. Optimized case-insensitive comparison results in significant speed increase. This may be useful for 1C.Introduced the following changes to the implementation of crash_info:
Improved performance of getting information on crashes of a backend by optimizing utility functions and commands.
Added details, like information about internal signal handlers, to
crash_infooutput files.
Added the enable_sorted_merge_join configuration parameter that enables or disables the query planner's use of merge joins in plans with sorting.
Added the auto_dump extension, which collects data for long-running and problematic queries and creates files with all information to reproduce them for troubleshooting.
Added the ldap2pg utility that automates the creation, update, and removal of Postgres Pro roles and users from an enterprise directory.
Added the pg_trgm_mchar extension, which allows fast trigram-based search for similar
mcharandmvarcharstrings. This extension also provides support of GIN indexes formcharandmvarchartypes. This may be useful for 1C.Added the pgpro_cpumeter extension, which provides access to a new CPU usage monitoring system function. This
pgpro_cpumeterfunction continuously collects and records information about CPU cores used by Postgres Pro server processes.Upgraded orafce to version 4.16.3.
Upgraded pgbouncer to version 1.25.0.
Upgraded pg_proaudit to provide the following enhancements and bugfixes:
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.
Fixed an issue with pg_proaudit failing to log events for the
INSERTcommand followingCREATEwithin anonymous code blocks (theDOcommand) and stored procedures/functions.Fixed an issue with pg_proaudit overloading a CPU core due to failed log rotation.
Upgraded pgpro_autopart to version 1.1 to fix an issue with the
ap_enable_automatic_partition_creationfunction, which failed if the table column name matched an SQL key word.Upgraded pgpro_bindump to fix compression level validation. Previously, pgpro_bindump enforced the same compression-level range regardless of the selected algorithm.
Upgraded pgpro_pwr to version 4.12 to support pgpro_stats 1.10.
Upgraded pgpro_stats to version 1.10 to provide the following enhancements and bug fixes:
Added new statistics to
pgpro_stats_statementsandpgpro_stats_totalsviews. These statistics were added to pg_stats_statements in Postgres Pro 18. Related functions are updated accordingly.Added the new
pgpro_stats_statements_filteredfunction to filter statistics similar to those provided in thepgpro_stats_statementsview by one or several fields:userid,dbid,queryid, andplanid. Calling this function is faster than querying thepgpro_stats_statementsview with appropriate values of these fields.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.
E.1.2. Migration to Version 18.1.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.
To migrate from PostgreSQL or a Postgres Pro Standard release based on a previous PostgreSQL major version, see the instructions in Postgres Pro Standard 18.0.1 Release Notes.