EDB Technical Update for Postgres Plus Advanced Server(Database Server 9.4.24.3)

Technical Update
Postgres Plus Advanced Server (Database Server 9.4.24.33)

WHAT’S NEW
This update is notifying you of a new software release Postgres Plus Advanced Server 9.4.24.33.

Highlights of 9.4.24.33 release include:

• Merge with community release 9.4.24
  • More information about this and other fixes in community PostgreSQL can be found  https://www.postgresql.org/about/news/1960/ and https://www.postgresql.org/docs/9.4/release-9-4-24.html
• Merge OpenSSL 1.1.1 library to address the items identified in Security Advisory 28-May-2019  - https://www.openssl.org/news/cl111.txt

This update contains the following fixes:

• RM44018 - Fix pg_dump to not dump pldbgapi extensions. [#886983]
• RM43983 - Convert RAW to VARCHAR before assigning to VARCHAR variable. [#865427]
• RM44047 - Correct CALL statement's function expression handling in ecpg.
• RM43962 - dblink_oci: Don't allow password and obfuscated_password options together.
• RM43873 - Fix to_char() for formats like spell mode, "IWW", "SPTH", "DDD", "D (day of the week)" etc. to make to_char() more redwood and PG compatible.

*References in the square brackets are the customer case numbers.

PLEASE NOTE
For Windows:

• If you have the system temp pointing to the non-default location then you must make sure it is secure and matches the permissions with  "C:\Users\%USERNAME%\AppData\Local\Temp"

For Linux:

• If you have PostGIS installed and choose to upgrade to PPAS 9.4.24.33 then you must also upgrade PostGIS.

IS THIS FOR ME?
This announcement is for EDB customers who are using, or are interested in, Postgres Plus Advanced Server and have a database subscription purchased for:

• EDB Postgres Enterprise Edition

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.4/instguide/toc.html  
• PDF: https://www.enterprisedb.com/edb-docs/static/docs/epas/9.4/Postgres_Plus_Advanced_Server_Installation_Guide_v9.4.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