Replication
Advanced logical
replication for PostgreSQL
Solutions for very high availability and geographically distributed workloads on multi-master PostgreSQL clusters, including data movement to or from Postgres, Oracle, and SQL Server clusters
Maintain very
high availability
PostgreSQL clusters deployed with BDR keep top-tier applications running
Choose the level
of consistency
Robust capabilities provide flexibility to meet application data loss requirements
Upgrade with near-
zero downtime
Rolling upgrades eliminate the largest source of unwanted production downtime
Oracle and SQL
Server integrations
Minimize application migration cutover times and avoid unnecessary additional licenses
Find the right fit for your data replication needs
The following tools are all fully supported by EDB in addition to being tested and released as part of the EDB portfolio:
BDR Enterprise
Full-featured replication solution including advanced conflict management and data-loss protection, with up to 2X performance of BDR Standard
- Guard application transactions with commit-at-most-once consistency even in the presence of node failures
- Conflict-free synchronous replication with two phase commit
- Configurable and customizable column-level conflict handling and transformation
- Concurrent updates using conflict-free replicated data types (CRDTs)
BDR Standard
Provides the essential multi-master replication capabilities for PostgreSQL clusters
- Enables application and database upgrades without requiring downtime
- Provides row-level last-update wins eventual consistency
- Supports continuous release environments through DDL replication with granular locking
- Tools to monitor operation, and verify data consistency
Replication Server
Provides PostgreSQL clusters with a robust solution for moving data to or from non-PostgreSQL databases
- Integrate with Oracle or SQL Server databases to offload reporting or to feed data to legacy applications
- Flexibility to replicate a subset of data from the source database
- Graphical user interface provides easy configuration and management
- Includes utility to validate data consistency between the source and target databases
Feature Comparison
| Capability | Community Logical | BDR Enterprise | BDR Standard | Replication Server |
|---|---|---|---|---|
| Replicate across major PostgreSQL versions | ||||
| Asynchronous replication | ||||
| Synchronous replication | ||||
| DDL replication | ||||
| Cascading | ||||
| Sequence handling | ||||
| Conflict-free replicated data types (CRDTs) | ||||
| Commit at most once | * | |||
| Configurable column-level conflict handling | ||||
| Customizable column-level conflict handling | ||||
| Customizable column-level transformation/filtering | ||||
| Parallel apply | ||||
| Single decoding worker | * | |||
| Application assessment tooling | * | |||
| Data consistency verification tool | ||||
| Management GUI | ||||
| Oracle to/from PostgreSQL | ||||
| Oracle to/from Postgres Advanced | ||||
| SQL Server to/from PostgreSQL | ||||
| SQL Server to/from Postgres Advanced | ||||
| PostgreSQL to/from Postgres Advanced | ||||
| License | PostgreSQL | EDB | EDB | EDB |
* feature is only available with EDB Postgres Extended at this time, and is expected to be available with EDB Postgres Advanced 14