EPAS (Database Server 12.5.6,11.10.19, 10.15.24, 9.6.20.27,9.5.24.30)

Customer Portal
Customer Portal

This article was originally published on November 20, 2020

WHAT’S NEW

 

This update is notifying you of a new software release of EDB Postgres™ Advanced Server 12.5.6, 11.10.19, 10.15.24, 9.6.20.27and 9.5.24.30. EDB Postgres Advanced Server is built on open-source PostgreSQL, with enhanced mission-critical features enhancements for security, DBA and developer productivity, performance diagnostics and Oracle database compatibility.


Highlights of 12.5.6 release include:

 

This release includes fixes for the following issues:

  • DB-770 - Don't emit useless messages about GSS or SSL negotiation failures. (#1048322, #1048143, #1018659)

  • DB-812 - As ROWIDs are generated by the system internally, values for the

rowid column are not dumped.  Thus we should not dump the rowid sequence state using setval() too.  Otherwise, it gives an error with data-only dump-restore. So skip dumping ROWID sequence state. (#1095864)

  • DB-743 - Fixed handling of multi-character record separators in edbldr. (#1051362)

  • DB-734 - Skip sending the ROWID to the subscriber. (#1055674)

  • DB-769 - Allow dynamic partition creation to non-owner insert queries. (#1073281)

  • DB-551 - ecpg: In non-Pro*C mode, evaluate EXEC SQL IFDEF/IFNDEF expression irrespective of the enclosed 'C' preprocessor directives and emit all 'C' preprocessor directives as-is to the output file. (#1007795)

  • DB-804 - Fixed crash with COPY FROM and/or foreign partition routing operations performed on libpq_dblink and oci_dblink FDW table.

  • DB-749 - We create this system column for all the foreign tables. However, only oci_dblink and libpq_dblink FDWs use it and the code, assumes that this column is used with these two FDWs only.  Which is wrong, this commit fixes the assertion failure when system column "__remote_rowid_" is selected.

  • DB-701 - Fixed group estimate for the remote relation in oci_dblink.

  • DB-107 - SPL: Fix row incompatibility issue when SUBTYPE is used in composite type.

 

Highlights of 11.10.19 release include:

This release includes fixes for the following issues:

  • DB-770 - Don't emit useless messages about GSS or SSL negotiation failures. (#1048322, #1048143, #1018659)

  • DB-743 - Fixed handling of multicharacter record separators in edbldr. (#1051362)

  • DB-551 - ecpg: In non-Pro*C mode, evaluate EXEC SQL IFDEF/IFNDEF expression irrespective of the enclosed 'C' preprocessor directives and emit all 'C' preprocessor directives as-is to the output file. (#1007795)

  • DB-804 - Fixed crash with COPY FROM and/or foreign partition routing operations performed on libpq_dblink and oci_dblink FDW table.

  • DB-749 - We create this system column for all the foreign tables. However, only oci_dblink and libpq_dblink FDWs use it and the code, assumes that this column is used with these two FDWs only.  Which is wrong, this commit fixes the assertion failure when system column "__remote_rowid_" is selected.

  • DB-701 - Fixed group estimate for the remote relation in oci_dblink.

  • DB-107 - SPL: Fix row incompatibility issue when SUBTYPE is used in composite type.

 

Highlights of 10.15.24 release include:

 
    • For Linux, bundled pgAdmin version is 4.21.
       

    • For Windows, bundled pgAdmin version 4.27. 

 

This release includes fixes for the following issues:

  • DB-770 - Don't emit useless messages about GSS or SSL negotiation failures. (#1048322, #1048143, #1018659)

  • DB-743 - Fixed handling of multicharacter record separators in edbldr. (#1051362)

  • DB-551 - ecpg: In non-Pro*C mode, evaluate EXEC SQL IFDEF/IFNDEF expression irrespective of the enclosed 'C' preprocessor directives and emit all 'C' preprocessor directives as-is to the output file. (#1007795)

  • DB-749 - We create this system column for all the foreign tables. However, only oci_dblink and libpq_dblink FDWs use it and the code, assumes that this column is used with these two FDWs only.  Which is wrong, this commit fixes the assertion failure when system column "__remote_rowid_" is selected.

  • DB-701 - Fixed group estimate for the remote relation in oci_dblink. 

  • DB-107 - SPL: Fix row incompatibility issue when SUBTYPE is used in composite type.

 

Highlights of 9.6.20.27 release include:

 
    • For Linux, Merge with OpenSSL 1.1.1h library.

 

This release includes fixes for the following issues:

  • DB-770 - Don't emit useless messages about GSS or SSL negotiation failures. (#1048322, #1048143, #1018659)

  • DB-743 - Fixed handling of multicharacter record separators in edbldr. (#1051362)

  • DB-551 - ecpg: In non-Pro*C mode, evaluate EXEC SQL IFDEF/IFNDEF expression irrespective of the enclosed 'C' preprocessor directives and emit all 'C' preprocessor directives as-is to the output file. (#1007795)

  • DB-749 - We create this system column for all the foreign tables. However, only oci_dblink and libpq_dblink FDWs use it and the code, assumes that this column is used with these two FDWs only.  Which is wrong, this commit fixes the assertion failure when system column "__remote_rowid_" is selected.

  • DB-705 - Fixed server crash during split partition when using edb_partition

Highlights of 9.5.24.30 release include:

 
    • For Linux, Merge with OpenSSL 1.1.1h library.

 

This release includes fixes for the following issues:

  • DB-770 - Don't emit useless messages about GSS or SSL negotiation failures. (#1048322, #1048143, #1018659)

  • DB-551 - ecpg: In non-Pro*C mode, evaluate EXEC SQL IFDEF/IFNDEF expression irrespective of the enclosed 'C' preprocessor directives and emit all 'C' preprocessor directives as-is to the output file. (#1007795)

  • DB-749 - We create this system column for all the foreign tables. However, only oci_dblink and libpq_dblink FDWs use it and the code, assumes that this column is used with these two FDWs only.  Which is wrong, this commit fixes the assertion failure when system column "__remote_rowid_" is selected.

  • DB-705 - Fixed server crash during split partition when using edb_partition

 

*References in the brackets are the customer case numbers. 

 

End-of-Support Reminder: 

We recommend you update to the most recent software version.  If you have not yet updated to the most current version, please note the end-of-support notes below*:   

  • Deprecated: EDB Postgres Advanced Server

  • Version:  9.5

  • End of Standard Support: February, 2021

TELL ME MORE

 

For more details, please review the EDB Postgres Advanced Server documentation: 

https://www.enterprisedb.com/edb-docs/p/edb-postgres-advanced-server

 

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:

 
  • Standard Subscription

  • Enterprise Subscription

 

HOW TO GET THE SOFTWARE

 

EDB Postgres Advanced Server is packaged and delivered via Stackbuilder Plus and on the EDB website, please visit:

https://www.enterprisedb.com/advanced-downloads

 

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

https://repos.enterprisedb.com/

 

To request the credentials required to access EDB repositories, please visit https://www.enterprisedb.com/repository-access-request


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


 

Was this article helpful?

0 out of 0 found this helpful