This article was originally published on May 13, 2019
Technical UpdateEDB Postgres Advanced Server (Database Server 9.5.17.23)
WHAT’S NEW
This update is notifying you of a new software release EDB Postgres™ Advanced Server 9.5.17.23. 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.
Highlights of 9.5.17.23 release include:
- Merge with community release 9.5.17
- More information about this and other fixes in community PostgreSQL can be found https://www.postgresql.org/about/news/1939/ and https://www.postgresql.org/docs/9.5/release-9-5-17.html
- Merge OpenSSL 1.0.2r library to address the items identified in Security Advisory 26-Feb-2019 - https://www.openssl.org/news/cl102.txt
- RM43930: Fix REASSIGN/DROP OWNED BY for synonym and directory objects. [Support ticket #855677]
- RM43047: Add support for synonym resolution to the type. [Support ticket #712701]
- RM43903: Fix ALTER USER MAPPING to treat obfuscated_password and password as same option. [Support ticket #847443]
- RM43923: Fix an issue with addition of timestamp and negative numbers. [Support ticket #853879]
- RM43915: Fix pg_dump/restore for VIEWs having DECODE expression by displaying implicit cast while deparsing DECODE expressions. [Support ticket #851791]
- RM41964: Preserve the shared dependencies on package in case of replace.
- RM41959: edbldr: Fix server while loading data into multiple table.
- RM41958: Qualify type name while deparsing package variable.
This announcement is for EDB customers who are using, or are interested in, EDB Postgres Advanced Server and have a database subscription purchased for:
- EDB Postgres Enterprise Edition
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 an RPM package that can be downloaded from the yum.enterprisedb.com repository. To setup your credentials and gain access to the yum repository, please submit a request: https://www.enterprisedb.com/repository-access-request
Please review 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