Why choose EDB Postgres 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.
Faster log-based replication
Replication of a subset of data
Advanced conflict detection
Integrate with Oracle or SQL Server
Easy config and management
Graphical user interface
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 PostgreSQL and Oracle or PostgreSQL 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.