2020年欧洲杯预测冠军

EDB Postgres Replication Server

Managing Postgres Replication Made Easy

Data replication for Postgres

EDB Postgres Replication Server (EPRS), a component of the EDB Postgres Platform2020年欧洲杯预测冠军, 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

  •  

    2020年欧洲杯预测冠军 Fast, log-based replication

  •  

    2020年欧洲杯预测冠军 Table subset replication

  •  

    2020年欧洲杯预测冠军 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.

2020年欧洲杯预测冠军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 PostgreSQL2020年欧洲杯预测冠军, as well as from Oracle and SQL Server.

2020年欧洲杯预测冠军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

2020年欧洲杯预测冠军Rich features for database replication in Postgres

  •  

    Multi-master replication

  •  

    2020年欧洲杯预测冠军 Faster log-based replication

  •  

    2020年欧洲杯预测冠军 Single-master replication

  •  

    Replication of a subset of data

  •  

    Advanced conflict detection

  •  

    2020年欧洲杯预测冠军 Integrate with Oracle or SQL Server

  •  

    Ease of configuration and management

  •  

    2020年欧洲杯预测冠军 A graphical user interface (GUI)