EDB Postgres Database High Availability and Disaster Recovery Design

Option 1 – EDB Database Architecture on  EDB Postgres Failover Manager (EFM) HA and DR with EFM (with Primary DB HA is configured at Primary and DR site and Disclosure/Data warehouse (DWH) DB HA is configured only at DR site) ·       On Primary DC Site, Between Primary node and Hot standby nodes, Asynchronous streaming replication is configured between Master (Primary DB) and two slave nodes (i.e. for Replication1 and Replication 2 DB). ·       Between Primary DC site to DR site over WAN, Asynchronous streaming replication is configured between Primary Master node and DR site slave nodes (i.e. for Primary DB and Replication DB). ·       EFM tool is used for Primary DB Master slave’s configuration for HA at Primary site and DR at DR site. In this case total 5 nodes EFM cluster for Primary DB (i.e. one Master and two slaves at Primary site and 2 slaves at DR site). ·       For Disclosure/Data War...