PostgreSQL Software
:ReplicationReplication allows you to do what you need to so PostgreSQL never loses your data and always has it available for you. Extreme high availability starts with replication.
Postgres-BDR
Postgres-BDR provides true high availability for PostgreSQL databases, providing up to five 9s of availability and flexible deployment options.
Also supported by EDB
Replication Server
EDB Postgres Replication Server (EPRS) provides a robust data platform that replicates between PostgreSQL databases in single-master or multi-master mode, or from non-PostgreSQL databases to PostgreSQL in single-master mode.
PostgreSQL Logical Replication
Logical replication is a method of replicating data objects and their changes, based upon their replication identity (usually a primary key).
Feature Comparison | Postgres-BDR | Replication Server | PostgreSQL Logical Replication |
|---|---|---|---|
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 |