This section will provide explanations for the offline installation of PostgreSQL 10 on Linux – including replication configuration with automatic failover (using REPMGR).
Please make sure you have the “HA DB rpms.zip” file which contains all the necessary RPMs.

For this first step of the procedure, we will use two DB servers, one as the Primary and the other as Secondary.

Installation Flow High Level Summary

  1. Extract & Install (on all DB servers)
  2. Configure PostgreSQL & allow ports – on all DB servers
  3. Restart PostgreSQL – on all DB servers
  4. Configure REPMGR – On the primary DB server
  5. Configure REPMGR – On the secondary DB server
  6. Configure REPMGR – On the secondary DB server (mandatory for DR)
  7. Pre-failover Actions