Version 6.2.16 v6.2

New features, enhancements, bug fixes, and other changes in EDB Postgres Replication Server 6.2.16 include the following:

TypeDescription
EnhancementReplication Server is certified to support PostgreSQL v14 and EDB Postgres Advanced Server v14.
EnhancementPerformance optimization for Synchronize operation when a MMR Publication has a SMR Subscription. [Support Ticket #74217]
Bug FixThe removepub CLI command removes a Publication while it has one or more Subscriptions. This issue is fixed. [Support Ticket #72194]
Bug FixFixed an issue where replication fails for the UUID data type in EDB Postgres Advanced Server to MS SQL Server permutation. [Support Ticket #73835]
Bug FixFixed an issue where the Synchronize operation failed to replicate NULL for a BLOB type for EDB Postgres Advanced Server to Oracle. [Support Ticket #74057]
Bug FixFixed case where wrong schema qualifier was picked up during history cleanup for EDB Postgres Advanced Server to Oracle and SQL Server permutations. [Support Ticket #72626]
Bug FixFixed loading of Replication History on Replication Console after restart of Publication Services when SMR subscription is associated with a MMR Publication. [Support Ticket #74217]
Bug FixFixed the upgrade issue related with the enhancement of shadow table triggers. [Support Ticket #74447]
Bug FixFixed an issue where redundant INSERT conflicts were recorded when a new table was added in the MMR Publication.
Bug FixIn a hybrid replication cluster, the cleanup shadow table routine is subject to remove unprocessed changes. This issue is fixed.
Bug FixThe Synchronize replication fails while replicating changes for a multi-level List Partition table. This issue is fixed.
Bug FixFixed the error where Snapshot fails for the third database in a MMR cluster.
Bug FixFixed an error that prevented creation of a row-level Filter based on the -> operator for JSONB data type.
Bug FixFixed the issue related with the reporting of incorrect missing privileges while registering Oracle Publication database.
Bug FixIn a hybrid cluster, batch is always applied using BUS (batch update using simple Statement) mode even when the user has opted for BUP mode (batch update using PreparedStatement). This issue is now fixed.
Bug FixFixed an issue where an INSERT conflict in MMR Publication is subject to failure of Synchronize operation for a target SMR Subscription in a hybrid cluster. [Support Ticket #75608]
Bug FixFixed an issue so that a validation error is reported when the CLI command createpub is executed without registering a Publication database.
Bug FixFixed the NoClassDefFoundError error (org/postgresql/replication/LogSequenceNumber) observed during data Snapshot operation for a RPM based installation on RHEL8/CENTOS8.
Bug FixFixed the error libpq JNI wrapper library is not available that occured while adding a database for WAL based replication.