Technical Update EDB Postgres Advanced Server (Database Server 9.6.19.26)

This article was originally published on August 17, 2020

WHAT’S NEW

This update is notifying you of a new software release EDB Postgres™ Advanced Server 9.6.19.26. 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.

PostgreSQL has now introduced a common YUM repository, details of which can be found in this newsletter: https://www.postgresql.org/about/news/2060/

Highlights of 9.6.19.26 release include:

● Merge with community release 9.6.19

○ More information about this and other fixes in community PostgreSQL can be found https://www.postgresql.org/about/news/2060/ and https://www.postgresql.org/docs/9.6/release-9-6-19.html

This update contains the following fixes:

● DB-682- In case of error coming from standard_planner global pointer is not getting clean up and end up with server crash. Commit fix dangling pointer de-reference for global index candidates. [#1026986]

● DB-640- Fix FF mode in Redwood to_char() datetime related functions.

● DB-639- Protect (timestamp + number) and (timestamp - number) against overflow.

● DB-592- Fix pg_dump to not dump build-in extensions.

● DB-477: edbldr: Disallow using NULLIF as SQL expression evaluation is not supported in the direct load.

● DB-301- edbldr: Fix assorted issues where ZONED data input length is less than the precision.

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

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:

● Enterprise Subscription

HOW TO GET THE SOFTWARE

This update is available via StackBuilder Plus.

This update is also available as native packages in the form of RPMs and DEBs, please visit:

https://repos.enterprisedb.com/

To setup your credentials and gain access to the yum repository, please submit a request: https://www.enterprisedb.com/repository-access-request.

Please refer 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

TROUBLESHOOTING

If you experience any problems installing the new software please contact Technical Support at:

Email: support@enterprisedb.com