This article was originally published on August 21, 2018
Technical UpdateEDB Postgres Advanced Server (Database Server 9.6.10.17)
This update is notifying you of a new software release EDB Postgres™ Advanced Server 9.6.10.17. EDB Postgres Advanced Server 9.6 is built on the open source PostgreSQL 9.6, which introduces an impressive number of improvements that enable databases to scale up and scale out in more efficient ways. PostgreSQL 9.6 also includes new monitoring capabilities that offer more visibility into the internal operations of the system such as vacuum progress monitoring and exposure of low level wait states in pg_stat_statements.
Highlights of 9.6.10.17 release include:
- Merge with community release 9.6.10
- More information about this and other fixes in community PostgreSQL can be found https://www.postgresql.org/about/news/1878/ and https://www.postgresql.org/docs/9.6/static/release-9-6-10.html
- RM43667 - Fix server crash on Windows when database containing password verify function is dropped. [Support Ticket #778591]
- RM43615 - ECPG: Treat "double" as regular "C" type instead of ecpg type. [Support Ticket #766415]
- RM43582 - ECPG PROC: Correct search path for system header files. [Support Ticket #714566]
- RM43608 - OCI DBLink: Use OCIPing to validate connection status to allow failover. [Support Ticket #761564]
- RM43621 - Reset lock wait timeout after successfully acquiring a lock. [Support Ticket #762664]
- RM43541 - ECPG: Fix parsing elif block. [Support Ticket #714566, 763085]
- RM43519 - Pass correct charset form to OCI LOB API in dblink_ora module. [Support Ticket #754525]
- RM43568 - ECPG: Raise "no data found" error with usebulk option. [Support Ticket #697421]
- RM43564 - Fix EDB's PAM authentication so that it doesn't report an authentication failure in case of PAM_TEXT_INFO messages. [Support Ticket #758027]
- RM43531 - EDB audit: Fix file rotation for edb_audit_rotation_day option. [Support Ticket #758750]
- RM43458 - Fix issue with data loss when using unicode data with utl_mail. [Support Ticket #736209]
- RM43268 - Fix the edb-validator parser to use handle FOREACH. [Support Ticket #757821]
- RM43376 - pg_upgrade: Recreate dropped columns correctly for EPAS partitioned table. [Support Ticket #735865]
- RM43118 - Bulk API: Fix issue with UPDATE statement that doesn't affect rows when the SET clause uses a recursive subquery. [Support Ticket #717187]
- RM43354 - utl_mail: Fix error message reported by exception.
- RM43478 - dbms_alert: Error out if shared memory is not yet allocated.
- RM43529 - Treat ROWNUM as parallel-restricted. [Support Ticket #757947]
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.6/instguide/toc.html
- PDF: https://get.enterprisedb.com/docs/EDB_Postgres_Advanced_Server_Installation_Guide_v9.6.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