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:
-
Merge with community release 12.5.
-
More information about this and other fixes in community PostgreSQL can be found https://www.postgresql.org/docs/12/release-12-5.html.
-
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:
-
Merge with community release 11.10
-
More information about this and other fixes in community PostgreSQL can be found https://www.postgresql.org/docs/11/release-11-10.html.
-
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:
-
Merge with community release 10.15
-
More information about this and other fixes in community PostgreSQL can be found https://www.postgresql.org/docs/10/release-10-15.html
-
For Linux, Merge with OpenSSL 1.1.1h library.
-
-
-
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:
-
Merge with community release 9.6.20
-
More information about this and other fixes in community PostgreSQL can be found https://www.postgresql.org/docs/9.6/release-9-6-20.html
-
-
-
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:
-
Merge with community release 9.5.24
-
More information about this and other fixes in community PostgreSQL can be found https://www.postgresql.org/docs/9.5/release-9-5-24.html
-
-
-
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