This document will provide explanations for the offline installation of PostgreSQL 10 on Linux – including replication configuration with automatic failover (using REPMGR). Please find the attached zip file (called “HA DB rpms.zip”) which contains all of the RPMs needed. Following is a short summary followed by a detailed procedure.

Steps Summary

  1. Extract & Install (on all nodes)
  2. Configure PostgreSQL & allow ports (on all nodes)
  3. Set up REPMGR
  4. Configure REPMGR Primary Node
  5. Configure REPMGR   Replica Node
  6. Pre-failover Actions