This article was originally published on February 14, 2020
Technical Update
EDB Postgres Advanced Server (Database Server 9.5.21.27)
WHAT’S NEW
This update is notifying you of a new software release EDB Postgres™ Advanced Server 9.5.21.27. 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.21.27 release include:
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: HOW TO GET THE SOFTWARE
This update is available via StackBuilder 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:
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
EDB Postgres Advanced Server (Database Server 9.5.21.27)
WHAT’S NEW
This update is notifying you of a new software release EDB Postgres™ Advanced Server 9.5.21.27. 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.21.27 release include:
- Merge with community release 9.5.21
- More information about this and other fixes in community PostgreSQL can be found https://www.postgresql.org/about/news/2011/ and https://www.postgresql.org/docs/9.5/release-9-5-21.html
- For Linux, Merge with OpenSSL 1.1.1d library.
- On Windows, SSL support is now provided through SafeLogic OpenSSL (1.0.2u).
- RM44151 - Skip expression simplification while fetching cursor rowtype. [#940052]
- RM44155 - Fixed execution of empty statements via expired accounts. [#942512]
- RM44175/DB-228 - Allow altering only its own password when expired while using password profiles.
- RM44123 - Fixed handling of subtypes in the extended protocol.
- RM44176 - Suppress error detail when password expire is set to infinity while using password profiles.
- RM44108 - Clear rolpasswordsetat when a user is renamed.
- RM44049 - Don't try to prune a relation when an OUTER JOIN is present to avoid possible projection of incorrect results.
- RM44146 - Fixed server crash while loading data into table through edbldr with CLOBBER_CACHE_ALWAYS build
- RM44109 - Fixed CREATE TRIGGER .. AUTHORIZATION behavior to avoid potential pg_upgrade failures.
- RM44138 - Fixed server crash for select query on table having VPD policy imposed with CLOBBER_CACHE_ALWAYS build.
- RM44130 - Fixed makeConst() call arguments order correctly in parse_spl_var().
- RM44118 - Change datatype from int to double to avoid wrap around in password profile.
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: HOW TO GET THE SOFTWARE
This update is available via StackBuilder 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