This article was originally published on August 18, 2020
WHAT’S NEWThis update is notifying you of a new software release EDB Postgres™ Advanced Server 10.14.23. EDB Postgres Advanced Server 10 is built on the open source PostgreSQL 10, which introduces an impressive number of improvements that enable databases to scale up and scale out in more efficient ways. PostgreSQL 10 introduces Native Partitioning, Logical Replication, SCRAM Authentication, additional Parallel Query capabilities as well as a host of other 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 10.14.23 release include:
● Merge with community release 10.14
○ 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/10/release-10-14.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-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-592 - Fix pg_dump to not dump build-in extensions.
● 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
This update is available from the EDB Postgres downloads website (https://www.enterprisedb.com/advanced-downloads) or via Stack Builder Plus.
This update is also available as native packages in the form of RPMs and DEBs, please visit:
https://repos.enterprisedb.com/
To setup your credentials and gain access to the yum repository, please submit a request: https://www.enterprisedb.com/repository-access-request
Please refer the Installation Guide for more details:
● HTML: https://www.enterprisedb.com/docs/en/10.0/EPAS_Inst_Guide_v10/toc.html
● PDF: https://get.enterprisedb.com/docs/EDB_Postgres_Advanced_Server_Installation_Guide_v10.pdf
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