EDB Postgres Replication Server

Data replication for Postgres

EDB Postgres Replication Server (EPRS), a component of the EDB Postgres Platform, 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

  •  

    Fast, log-based replication

  •  

    Table subset replication

  •  

    Table data filtering

  •  

    Replication scheduling

Graphic of replicating servers

マルチマスターレプリケーション

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.

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

Just some of the reasons to choose EPRS over other solutions, like Slony, BDR, and pgLogical.

  •  

    マルチマスターレプリケーション

  •  

    Faster log-based replication

  •  

    Single-master replication

  •  

    Replication of a subset of data

  •  

    Advanced conflict detection

  •  

    Integrate with Oracle or SQL Server

  •  

    Ease of configuration and management

  •  

    A graphical user interface (GUI)