edb-replication

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

high-availability

Maintain very high availability

PostgreSQL clusters deployed with BDR keep top-tier applications running

horizontal

Choose the level of consistency

Robust capabilities provide flexibility to meet application data loss requirements

easy

Upgrade with near-
zero downtime

Rolling upgrades eliminate the largest source of unwanted production downtime

convert

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 checkmark checkmark checkmark checkmark
Asynchronous replication checkmark checkmark checkmark checkmark
Synchronous replication checkmark checkmark
DDL replication checkmark checkmark
Cascading checkmark checkmark
Sequence handling checkmark checkmark
Conflict-free replicated data types (CRDTs) checkmark
Commit at most once checkmark
Configurable column-level conflict handling checkmark
Customizable column-level conflict handling checkmark
Customizable column-level transformation/filtering checkmark
Application assessment tooling checkmark
Data consistency verification tool checkmark checkmark checkmark
Management GUI checkmark
Oracle to/from PostgreSQL checkmark
Oracle to/from Postgres Advanced checkmark
SQL Server to/from PostgreSQL checkmark
SQL Server to/from Postgres Advanced checkmark
PostgreSQL to/from Postgres Advanced checkmark
License Proprietary Proprietary Proprietary