This article was originally published on August 17, 2020
WHAT’S NEWThis update is notifying you of a new software release EDB Postgres™ Advanced Server 12.4.5 EDB Postgres Advanced Server 12 is built on open-source PostgreSQL 12, which introduces myriad enhancements that enable databases to scale up and scale out in more efficient ways. PostgreSQL 12 builds upon the existing partitioning techniques by allowing faster partition pruning along with additional partition improvements, several btree index advancements, CTE inlining, SERIALIZABLE for parallel query and many new features and capabilities.
PostgreSQL has now introduced a common YUM repository, details of which can be found in this newsletter: https://www.postgresql.org/about/news/2060/
Highlights of 12.4.5 release include:
● Merge with community release 12.4.
○ More information about this and other fixes in community PostgreSQL can be found https://www.postgresql.org/about/news/2060/ and https://www.postgresql.org/docs/12/release-12-4.html.
● EPAS-12 now has llvm support on RHEL-8.
● Please note that UpdateMonitor is deprecated from this release onwards.
This update contains the following fixes:
● DB-682 - In case of error coming from standard_planner global pointer is not getting clean up and end up with server crash. Commit fix dangling pointer de-reference for global index candidates. [#1026986]
● DB-597 - Fix minor problems with non-exclusive backup cleanup [#1009383]
● DB-537 - edb_enable_pruning: Fix to follow the same order to compute the hash values of partition key in which it's defined. [#1010975]
● DB-371 - Make the scope of an autonomous transaction include the exception block. [#977822]
● DB-406 - Throw a proper error when ROWID used with partition table.
● DB-648 - Adjust Makefile to use CXXFLAGS with HP-UX C compiler.
● DB-640 - Fix FF mode in Redwood to_char() datetime related functions.
● DB-639 - Protect (timestamp + number) and (timestamp - number) against overflow.
● DB-477 - edbldr: Disallow using NULLIF as SQL expression evaluation is not supported in the direct load.
● DB-154 - edb_partition: Don't try to prune a relation falling on the nullable side of a join for HASH partition when edb_enable_pruning is True.
● DB-301 - edbldr: Fix assorted issues where ZONED data input length is less than the precision.
● DB-438 - edbldr: Failed to load data for partition table having foreign key.
*References in the square brackets are the customer case numbers.
IS THIS FOR ME?
This announcement is for EDB customers who are using, or are interested in, EDB Postgres Advanced Server and have a database subscription purchased for:
● Enterprise Subscription
HOW TO GET THE SOFTWARE
EDB Postgres Advanced Server v12 is packaged and delivered as a series of interactive installers available via Stackbuilder Plus and on the EnterpriseDB website. Visit:
https://www.enterprisedb.com/advanced-downloads
This update is also available as native packages in the form of RPMs and DEBs, please visit:
https://repos.enterprisedb.com/
To request the credentials required to access EnterpriseDB repositories, please visit https://www.enterprisedb.com/repository-access-request
Documentation is provided on the EnterpriseDB website. Visit:
https://www.enterprisedb.com/resources/product-documentation
TROUBLESHOOTING
If you experience any problems installing the new software please contact Technical Support at:
Email: support@enterprisedb.com
Phone: US: +1-732-331-1320 or 1-800-235-5891
UK: +44-2033719820
Brazil: +55-2139581371
India: +91-20-66449612