Replication
Replication 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
EDB Postgres Distributed
EDB Postgres Distributed provides extreme high availability for Postgres 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 | EDB Postgres Distributed | 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 |