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 9.5.23.29. EDB Postgres Advanced Server 9.5 is built on the open source PostgreSQL 9.5 and integrated features include UPSERT, BRIN Indexes, pg_rewind, GROUPING SETS/CUBE/ROLLUP, JSONB-modifying operators and functions and foreign table inheritance.
EPAS 9.5 introduced new improvements features like password profiles, audit log tagging and 12th generation compatibility with Oracle Database.
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 9.5.23.29 release include:
● Merge with community release 9.5.23
○ 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/9.5/release-9-5-23.html
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-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 via StackBuilder 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/9.5/instguide/toc.html
● PDF: https://get.enterprisedb.com/docs/EDB_Postgres_Advanced_Server_Installation_Guide_v9.5.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