The following procedure should be executed with sudo permissions on all three servers – Primary DB, Secondary DB and the DR DB.

  1. Download the HA DB rpms.zip file to the home folder of the Siemplify user.
  2. Enter the following command:
  3. sudo su -
  4. cd /home Alternatively, go to the folder that contains the zip with the RPMs
  5. unzip HA DB rpms.zip
  6. yum remove libicu-50.2-4.el7_7.x86_64 -y
  7. yum install *.rpm -y
  8. systemctl enable postgresql-10
  9. passwd postgres Enter a password here for the postgres user
  10. su - postgres
  11. ssh-keygen -t rsa
  12. ssh-copy-id postgres <OTHER_IP_ADDRESS> Add here the IP address of the other DB
  13. Make sure all the .ssh key files have the right permissions
    1. chmod 700 ~/.ssh
    2. chmod 600 ~/.ssh/authorized_keys
    3. chmod 644 ~/.ssh/known_hosts
    4. chmod 600 ~/.ssh/id_rsa
    5. chmod 644 ~/.ssh/id_rsa.pub
    6. restorecon -R -v ~/.ssh
  14. Validate passwordless connection between the servers using
    ssh postgres !https://manula.r.sizr.io/large/user/14758/img/atsign.png! <remoteIP>
  15. exit
  16. PostgreSQL 10 will be installed with all the neccesary packages of REPMGR 5.0.
    To check the status of the postgres service use the following command:
    systemctl status postgresql-10