This article was originally published on August 17, 2020
WHAT’S NEW
This update is notifying you of a new software release EDB Postgres™ Advanced Server 11.9.16. EDB Postgres Advanced Server 11 is built on the open source PostgreSQL 11, which introduces an impressive number of improvements that enable databases to scale up and scale out in more efficient ways. PostgreSQL 11 introduces increased robustness and performance to partitioning, transactions supported in stored features, enhanced capability for query parallelism and many more features.
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 11.9.16 release include:
● Merge with community release 11.9
○ 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/11/release-11-9.html.
● 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-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-640 - Fix FF mode in Redwood to_char() datetime related functions.
● DB-639 - Protect (timestamp + number) and (timestamp - number) against overflow.
● RM43953 - Commit move the schema grant statement from edb-sys.sql to code, in order to fix the pg_upgrade for --no-redwood-compat mode.
● DB-477 - edbldr: Disallow using NULLIF as SQL expression evaluation is not supported in the direct load.
● DB-301 - edbldr: Fix assorted issues where ZONED data input length is less than the precision.
*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 v11 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