Movatterモバイル変換

• Added the newOLD_PASSWORD_TIME andOLD_PASSWORD_MAX parameters for theCREATE PROFILE andALTER PROFILE commands. These parameters are required to enable authentication with the previous password.OLD_PASSWORD_TIME specifies for how long the previous password can be used for authentication alongside the new one.OLD_PASSWORD_MAX specifies the number of attempts to authenticate with the previous password before it is locked. Theoid andpassloginattempts fields were added to thepg_role_password catalog, and thepfloldpasswordtime andpfloldpasswordmax fields were added to thepg_profile catalog to display information related to previous passwords.

• Implemented password masking in the server log by default to protect sensitive data from being revealed.

• Added the newcompute_plan_id configuration parameter that allows enabling and disabling in-core computation of query plan identifiers. Also added theplan_id field to thepg_stat_activity view to display plan identifiers.

• Added the newextra_query_transformations configuration parameter that controls additional transformations ofANY correlated subqueries intoLATERAL joins. This parameter replaces theenable_any_to_lateral_transformation andenable_extra_transformations parameters that were removed.

• Added new values of thePGPRO_TUNE environment variable used byinitdb.

• Inherited the vanilla implementation of automatic removal of some unnecessary table self-joins. The correspondingenable_self_join_removal configuration parameter is removed; useenable_self_join_elimination instead.

• Removed the deprecatedpgpro_version,pgpro_edition, andpgpro_build functions. Use thepgpro_version,pgpro_edition, andpgpro_build configuration parameters instead.

• Ended support for Ubuntu 25.04 and Debian 11.

• Upgradedaqo to version 4.0 to implement optimizations that improve performance and significantly reduce overhead of query planning.

• Upgradedpg_proaudit to provide the following enhancements:

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

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

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

• Upgradedpgpro_pwr to version 4.11, which provides optimizations and bug fixes. Notable changes are as follows:

  • Improvedtake_sample time tracking.

  • Added a possibility to exclude server connection strings from dumps.

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

• Improved the behavior ofpgpro_stats similarly topro_stat_statements. The changes are:

  • Allow the parameterization ofSET values.

    This reduces the bloat caused bySET statements with differing constants.

  • Allow the parameterization of constant lists.

• Upgradedorafce to version 4.16.2.

• Upgradedpg_filedump to version 18.0.

• Upgradedpg_probackup to version 2.8.11.

• Upgradedpgpro_controldata to version 18.1.0.

• Upgradedpgvector to version 0.8.1.

• Upgradedtds_fdw to version 2.0.5.

• Disabledonline_analyze. This module is not recommended for use with modern versions of1C. However, it can be enabled if needed.

Note

To avoid conflicts, do not use thepostgrespro-std-18 package to install the newPostgres Pro binaries. Use the individual packages instead. In this case, server autostart needs to be enabled manually, if required. For details on the available packages, seeChapter 16.