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 solution including advanced conflict management and data-loss protection
- Configurable column-level conflict resolution with customizable conflict handling and transformation
- Concurrent updates using conflict-free replicated data types (CRDTs)
- Conflict-free synchronous replication with two-phase commit
- Guard applications from commiting synchronous transactions more than once
BDR Standard
Provides the essential multi-master replication capabilities for PostgreSQL clusters
- Extends PostgreSQL logical replication beyond unidirectional, standby use cases
- Provides row-level consistency in multi-master replication architectures
- Enables application and database upgrades without requiring downtime
- Tools to assess applications, 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 | ||||
| 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 |