This article was originally published on May 18, 2020
Technical Update
EDB Postgres Advanced Server (Database Server 12.3.4)
WHAT’S NEW
This update is notifying you of a new software release EDB Postgres™ Advanced Server 12.3.4. EDB Postgres Advanced Server 12 is built on open-source PostgreSQL 12, which introduces myriad enhancements that enable databases to scale up and scale out in more efficient ways. PostgreSQL 12 builds upon the existing partitioning techniques by allowing faster partition pruning along with additional partition improvements, several btree index advancements, CTE inlining, SERIALIZABLE for parallel query and many new features and capabilities.
PostgreSQL has now introduced a common YUM repository, details of which can be found in this newsletter: https://www.postgresql.org/about/news/2027/
Highlights of 12.3.4 release include:
This update contains the following fixes:
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
EDB Postgres Advanced Server v12 is packaged and delivered as a series of interactive installers available via Stackbuilder Plus and on the EnterpriseDB website. Visit:
https://www.enterprisedb.com/advanced-downloads
This update is also available as an RPM and SLES package that can be downloaded from:
yum.enterprisedb.com and https://zypp.enterprisedb.com/ repository respectively.
Debian/Ubuntu Packages are available for download from:
https://apt.enterprisedb.com/
To request the credentials required to access EnterpriseDB repositories, please visit https://www.enterprisedb.com/repository-access-request
Documentation is provided on the EnterpriseDB website. Visit:
https://www.enterprisedb.com/resources/product-documentation
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
EDB Postgres Advanced Server (Database Server 12.3.4)
WHAT’S NEW
This update is notifying you of a new software release EDB Postgres™ Advanced Server 12.3.4. EDB Postgres Advanced Server 12 is built on open-source PostgreSQL 12, which introduces myriad enhancements that enable databases to scale up and scale out in more efficient ways. PostgreSQL 12 builds upon the existing partitioning techniques by allowing faster partition pruning along with additional partition improvements, several btree index advancements, CTE inlining, SERIALIZABLE for parallel query and many new features and capabilities.
PostgreSQL has now introduced a common YUM repository, details of which can be found in this newsletter: https://www.postgresql.org/about/news/2027/
Highlights of 12.3.4 release include:
- Merge with community release 12.3.
- More information about this and other fixes in community PostgreSQL can be found https://www.postgresql.org/about/news/2038/ and https://www.postgresql.org/docs/12/release-12-3.html.
- On Windows, OpenSSL 1.0.2v is supported.
- The sslutils 1.3 version, which is a Postgres extension that provides SSL certificate generation functions to Advanced Server.
- Enhancements implemented in clone schema 1.12 and parallel_clone 1.7.
- Please note that this is the last release supporting UpdateMonitor and it will be deprecated from the forthcoming releases.
This update contains the following fixes:
- DB-380 - dblink_oci: Add GUC to control the scan type for the remote statement. New GUC edb_dblink_oci.rescan = {serializable | scroll}, will allow a user to choose the scrollable vs non-scrollable cursor. [#947738]
- DB-435 - Fix dblink_ora_copy() when copying to EPAS table having ROWID. [#964115]
- DB-409 - pg_upgrade: Ignore TOAST for partitioned tables. [#983824]
- DB-362 - Fix server crash when an empty input string is passed to to_timestamp. [#981139]
- DB-187 - Do not push ROWNUM to the child scan/join targets paths and disable partition-wise aggregate when query has ROWNUM.
- DB-319 - Median: Fix potential incorrect result or crash by switching to the right memory context.
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:
- EDB Postgres Enterprise Edition
HOW TO GET THE SOFTWARE
EDB Postgres Advanced Server v12 is packaged and delivered as a series of interactive installers available via Stackbuilder Plus and on the EnterpriseDB website. Visit:
https://www.enterprisedb.com/advanced-downloads
This update is also available as an RPM and SLES package that can be downloaded from:
yum.enterprisedb.com and https://zypp.enterprisedb.com/ repository respectively.
Debian/Ubuntu Packages are available for download from:
https://apt.enterprisedb.com/
To request the credentials required to access EnterpriseDB repositories, please visit https://www.enterprisedb.com/repository-access-request
Documentation is provided on the EnterpriseDB website. Visit:
https://www.enterprisedb.com/resources/product-documentation
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