EDB Postgres Advanced Server 17.5 release notes v17

Released: 09 May 2025

EDB Postgres Advanced Server 17.5 includes the following enhancements and bug fixes:

Deprecation

With the release of EDB Postgres Advanced Server 17, the DRITA is being deprecated and will not be included in EDB Postgres Advanced Server 18. This decision follows the introduction of EDB’s PWR and edb_wait_states extensions, which offer improved diagnostic capabilities compared to DRITA. These new extensions provide a diagnostic experience more closely aligned with Oracle’s AWR reports, making DRITA obsolete.

Note

The pgAgent and adminpack packages are end of life in EDB Postgres Advanced Server 17 and later.

TypeDescriptionAddresses               
Upstream mergeMerged with community PostgreSQL 17.5. This release includes a fix for CVE-2025-4207. See the PostgreSQL 17.5 Release Notes for more information.
Bug fixModified SUBSTRB() to accept clipped slices, aligning its behavior with Redwood by allowing incomplete character boundaries and improving compatibility.#45636
Bug fixFixed the alteruser utility to set the encoding correctly to avoid a possible server crash.
Bug fixFixed the behavior of edb_dynatune to ensure it functions as expected.#45385
Bug fixFixed the definition of the sys.*_scheduler_jobs views in dbms_scheduler to populate previously missing column values, and bumped the extension version to reflect the change.#48375
Bug fixFixed an issue in dbms_job where jobs with identical start times caused dba_jobs and user_jobs views to return incorrect results by updating the view definitions. Also, bumped the extension version to reflect the change.#38664
Bug fixFixed computation of nullingrels in Redwood-style left joins, which previously caused errors such as wrong varnullingrels (b) (expected (b 10)) for Var 3/2.#42059