This article was originally published on February 22, 2019
Technical UpdateEDB Postgres Advanced Server (Database Server 9.5.16.22)
WHAT’S NEW
This update is notifying you of a new software release EDB Postgres™ Advanced Server 9.5.16.22. EDB Postgres Advanced Server 9.5 is built on the open source PostgreSQL 9.5, which introduces an impressive number of improvements that enable databases to scale up and scale out in more efficient ways. PostgreSQL 9.5 introduces Native Partitioning, Logical Replication, SCRAM Authentication, additional Parallel Query capabilities as well as a host of other new features and capabilities.
Highlights of 9.5.16.22 release include:
- Merge with community release 9.5.16
- More information about this and other fixes in community PostgreSQL can be found https://www.postgresql.org/about/news/1920/ and https://www.postgresql.org/docs/9.5/release-9-5-16.html
- RM43888 Fix possible server crash in bytea_smaller() and bytea_larger(). [Support Ticket #833954]
- RM41971 Fix possible server crash when attempting to use named-parameter syntax to call a function whose arguments are unnamed.
- RM43593 Fix failure to dump triggers on child partitioned tables when upgrading from a version prior to v10.
- RM43843 Fix incorrect handling of IYYY mask when to_char() is used. [Support Ticket #823847]
- RM43832 Fix wrong answer when to_date() is used with the RR mask for with or during a year ending in 00. [Support Ticket #822321]
- RM43809 Fix CREATE ROLE to honor NOSUPERUSER even when IDENTIFIED BY is specified.
- RM43799 Even if pg_restore is run with --if-exists, do not add IF EXISTS to DROP PROCEDURE commands, which in this version do not support it. [Support Ticket #814694]
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 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
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