edb-replication

EDB Postgres Replication Server

Managing Postgres
Replication Made Easy

Robust data platform that replicates between Postgres databases in single-master or multi-master mode, or from non-Postgres databases to Postgres in single-master mode

Downloads View plans Docs

Why choose EDB Postgres Replication Server?

EDB Postgres Replication Server (EPRS) provides a robust data platform that replicates between Postgres databases
in single-master or multi-master mode, or from non-Postgres databases to Postgres in single-master mode.

drives
Multi-master replication
duplicate
Faster log-based replication
replication
Single-master replication
subset
Replication of a subset of data
conflict
Advanced conflict detection
network
Integrate with Oracle or SQL Server
config-management
Easy config and management
gui
Graphical user interface

Key Features

Replication Server multiple

Multi-Master Replication

EDB Postgres Replication Server enables geographically distributed Postgres data management, with fast read/write access in every location. With multiple masters data is secured, and accessible on any other master almost immediately. Queries can be redirected to another master or replica in case of a failure.

EPRS is based on PostgreSQL’s logical decoding. It can extract relevant changes for replication from Write-Ahead Logs (WAL) instead of using triggers. This eliminates overhead on publication databases and significantly reduces latency.

Trigger-based replication is used when replicating from earlier versions of EDB Postgres Advanced Server and PostgreSQL, as well as from Oracle and SQL Server.

In the event of a data update conflict, EPRS offers conflict resolution to prevent data inconsistencies.

Replication Server

Replication from SQL
Server or Oracle to Postgres

EDB Postgres Replication Server enables single-master replication between Postgres and Oracle or Postgres and SQL Server. Configurations are supported with PostgreSQL and EDB Postgres Advanced Server.

When replicating either from or to a remote data source, EPRS makes specific data available within the remote database as one leg of data federation.

When replicating from a remote database in a heterogeneous environment, read replicas for reporting can be added. This can reduce or eliminate license costs for add-ons such as Oracle Active Data Guard.

edb-replication

Get Started with Replication Server

View plans