EDB Postgres Distributed 5.2.0 release notes v5
Released: 04 Aug 2023
EDB Postgres Distributed version 5.2.0 is a minor version of EDB Postgres Distributed.
Highlights of EDB Postgres Distributed 5.2.0
- Parallel Apply is now available for PGD’s Commit at Most Once (CAMO) synchronous commit scope and improving replication performance.
- Parallel Apply for native Postgres asynchronous and synchronous replication has been improved for workloads where the same key is being modified concurrently by multiple transactions to maintain commit sequence and avoid deadlocks.
- PGD Proxy has added HTTP(S) APIs to allow the health of the proxy to be monitored directly for readiness and liveness. See Proxy health check.
Recommended upgrade
We recommend that users of PGD 5.1 upgrade to PGD 5.2.
PostgreSQL version compatibility
This version is required for EDB Postgres Advanced Server versions 12.15, 13.11, 14.8, and later.
| Component | Version | Type | Description |
|---|---|---|---|
| BDR | 5.2.0 | Feature | Added Parallel Apply for synchronous commit scopes with CAMO. |
| BDR | 5.2.0 | Feature | Allow multiple SYNCHRONOUS_COMMIT clauses in a commit scope rule. |
| BDR | 5.2.0 | Enhancement | BDR extension now allows transaction streaming with SYNCHRONOUS_COMMIT and LAG CONTROL commit scopes. |
| BDR | 5.2.0 | Enhancement | Improved handling of concurrent workloads with Parallel Apply. |
| BDR | 5.2.0 | Enhancement | Modified bdr.stat_subscription for new columns. |
| BDR | 5.2.0 | Bug fix | Fixed an issue by allowing a logical join of node if there are foreign key constraints violations. (RT91745) |
| BDR | 5.2.0 | Bug fix | Changed group_raft_details view to avoid deadlock possibility. |
| BDR | 5.2.0 | Bug fix | Fixed an issue by adding ability to log the extension upgrade. |
| BDR | 5.2.0 | Bug fix | Added check for conflicting node names. |
| BDR | 5.2.0 | Bug fix | Fixed a crash during Raft manual snapshot restore. |
| BDR | 5.2.0 | Bug fix | Fixed an issue whereby BDR extension was attempting to establish consensus connections to parting or parted nodes. |
| BDR | 5.2.0 | Bug fix | Fixed tcp_user_timeout GUC to use the correct unit. |
| BDR | 5.2.0 | Bug fix | Fixed the consensus snapshot compatibility with PGD 3.7. (RT93022) |
| BDR | 5.2.0 | Bug fix | Fixed an issue whereby a crash occurred when BDR extension is used with pgaudit. |
| BDR | 5.2.0 | Bug fix | Fixed an issue by skipping parting synchronization to witness node. |
| BDR | 5.2.0 | Bug fix | Fixed an issue by now generating correct keepalive parameters in connection strings. |
| BDR | 5.2.0 | Bug fix | Enabled various scenarios of switching nodes between groups and their subgroups, for example, transition node from a group to any of the nested subgroups. |
| BDR | 5.2.0 | Bug fix | Reduced the amount of WAL produced by consensus on idle server. |
| BDR | 5.2.0 | Bug fix | Fixed deadlock on autopartition catalogs when a concurrent DROP EXTENSION is executing. |
| BDR | 5.2.0 | Bug fix | Fixed sporadic failure when dropping extension after node restart |
| BDR | 5.2.0 | Bug fix | Added a workaround for crash due to pgaudit bug. |
| BDR | 5.2.0 | Bug fix | Fixed deadlock between consensus and global monitoring queries. |
| BDR | 5.2.0 | Bug fix | Fixed query cancellation propagation across bdr.run_on_all_nodes. |
| BDR | 5.2.0 | Bug fix | Fixed an issue by disallowing invoking bdr.run_on_nodes(), bdr.run_on_group() and bdr.run_on_all_nodes() on parted nodes. |
| CLI | 5.2.0 | Enhancement | Added new GUCs verification in verify-settings command. |
| CLI | 5.2.0 | Bug fix | Fixed an issue by truncating the long value of GUC in tabular output of verify-settings. |
| CLI | 5.2.0 | Bug fix | Fixed connect_timeout issue when sslmode=allow or sslmode=prefer by upgrading database driver library version. |
| Proxy | 5.2.0 | Feature | Added HTTP(S) APIs for Proxy health check. |
| Proxy | 5.2.0 | Enhancement | Improved route change events handling mechanism. |
| Proxy | 5.2.0 | Enhancement | Added retry mechanism on consensus query error. |
| Proxy | 5.2.0 | Bug fix | Fixed connect_timeout issue when sslmode=allow or sslmode=prefer by upgrading database driver library version. |
- On this page
- Highlights of EDB Postgres Distributed 5.2.0