This article was originally published on May 11, 2023
WHAT’S NEW
This update is notifying you of new software releases to EDB repositories of PostgreSQL, EDB Postgres Advanced Server and EDB Postgres Extended Server.
EDB Postgres Advanced Server is built on open-source PostgreSQL with enhanced mission-critical features for security, Oracle database compatibility, DBA and developer productivity, and performance diagnostics.
EDB Postgres Extended Server is built on open-source PostgreSQL with a limited number of additional features that cannot be implemented as an extension, such as Transparent Data Encryption (requires v15) and enhanced replication optimization used with EDB Postgres Distributed, and maintains parity with upstream PostgreSQL in other respects.
Database Distributions Versions Released
PostgreSQL 15.3, 14.8, 13.11, and 12.15
EDB Postgres Advanced Server 15.3.0, 14.8.0, 13.11.15, 12.15.19, and 11.20.31
EDB Postgres Extended Server 15.3.0, 14.8.0, 13.11 r1.1.13, 12.15 r1.1.15, 11.20 r2.1.15, and 11.20 r1.6.35
Highlights of these releases include:
- Merge with community release. More information about this and other fixes in community PostgreSQL can be found:
- New extensions: index_advisor and sql_profiler are separate extensions now and can be downloaded independently from the EDB Repos.
The following fixes are included in EDB Postgres Advanced Server:
Advanced Server Release |
Description |
11 and above |
Profile: Don't dump "PASSWORD EXPIRE AT" when the password status is not expired to avoid marking the user account as expired after an upgrade. (#92285) |
edb_enable_pruning: Fix unexpected error. (#89863) [Amul] Fix unexpected errors while comparing the value of different types in partition pruning. | |
edbldr: Fix cancel_load() for interrupted by Ctrl-c (SIGINT). (#88734) | |
pg_dump: Set correct object descriptions for redaction policy to make pg_dump work cleanly with --clean and --if-exists options. | |
Fix assertion failure while terminating the process within the autonomous transaction. | |
Fix the password profile behavior after the password grace time has changed meanwhile. | |
Fix pg_dump to dump password verify function for the user profile. | |
11, 12, 13, 14 |
Fix corner-case uninitialized-variable issues in SPL. |
12 and above |
Fix memory leakage in anonymous blocks that use cast expressions. (#88816) |
13 and above |
edb_partition: Fix EOF error from newly created dynamic partition. [Amul] Fix ‘unexpected data beyond EOF’ error while accessing newly created dynamic partitions in high concurrency. |
14 and above |
pg_dump: Don't dump permissions of sequences we are not creating. (#89466) |
Fix query jumble to take edb_wrap into consideration while generating queryid. | |
Fix compiler warning in userenv(). | |
Only 15 |
Set location for the default DECODE result. |
Fix possible server crash in range partition pruning for NULL values. |
*References in the parenthesis correspond to customer case numbers.
For more details, please review the EDB Postgres Advanced Server or EDB Postgres Extended Server documentation:
https://www.enterprisedb.com/docs/epas/latest/
https://www.enterprisedb.com/docs/pge/latest/
IS THIS FOR ME?
This announcement is for EDB customers who are using, or are interested in, EDB Postgres Advanced Server or EDB Extended Server (used with EDB Postgres Distributed) and have a database subscription purchased for:
- EDB Standard Plan
- EDB Enterprise Plan
- EDB Extreme HA Plan
HOW TO GET THE SOFTWARE
EDB Postgres Advanced Server and EDB Postgres Extended Server are available as native packages in the form of RPMs and DEBs, visit EDB Repos. To request the credentials required to access EDB repositories, visit Create new account.
**Please note that this release is available for the Linux platforms only and Windows installers will follow soon.
TROUBLESHOOTING
If you experience any problems around the installation, migration, upgrade or general use of your EDB software, please contact our Technical Support teams. Customers may reach us at https://techsupport.enterprisedb.com, and we're also available 24x7 via email and phone at the details below:
Customer Support Email: techsupport@enterprisedb.com
Trial Use Assistance: trial-help@enterprisedb.com
US +1-732-331-1320 / 1-800-235-5891
UK +44-2033719820
Brazil +55-2139581371
India +91-20-66449612