EDB Postgres Replication Server

Managing Postgres Replication Made Easy

Data replication for Postgres

EDB Postgres Replication Server (EPRS), a component of the EDB Postgres Platformbst365体育投注网址大全, 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.

With it's graphical user interface (GUI), EPRS offers:


    Geographic load balancing


    Simplified real-time migration


    Heterogeneous data integration


    bst365体育投注网址大全 Fast, log-based replication


    bst365体育投注网址大全 Table subset replication


    bst365体育投注网址大全 Table data filtering


    Replication scheduling

Graphic of replicating servers

Multi-Master Replication

Graphic of multiple master servers

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.

bst365体育投注网址大全In the event of a data update conflict, EPRS offers conflict resolution to prevent data inconsistencies.

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.

Graphic of replication with Oracle

Advantages of EDB Postgres Replication Server

bst365体育投注网址大全Rich features for database replication in Postgres


    Multi-master replication


    bst365体育投注网址大全 Faster log-based replication


    bst365体育投注网址大全 Single-master replication


    Replication of a subset of data


    Advanced conflict detection


    Integrate with Oracle or SQL Server


    Ease of configuration and management


    bst365体育投注网址大全 A graphical user interface (GUI)