When there is a problem with the vRealize Automation appliance Postgres database, you manually fail over to a replica vRealize Automation appliance node in the cluster.

Before you begin

  • Configure a cluster of vRealize Automation appliance nodes. Each node hosts a copy of the embedded Postgres appliance database.

About this task

Follow these steps when the Postgres database on the master vRealize Automation appliance node fails or stops running.

Procedure

  1. Remove the master node IP address from the external load balancer.
  2. Log in to the vRealize Automation appliance management interface as root.

    https://vrealize-automation-appliance-FQDN:5480

  3. Click vRA Settings > Database.
  4. From the list of database nodes, locate the replica node with the lowest priority.

    Replica nodes appear in ascending priority order.

  5. Click Promote and wait for the operation to finish.

    When finished, the replica node is listed as the new master node.

  6. Correct issues with the former master node and add it back to the cluster:
    1. Isolate the former master node.

      Disconnect the node from its current network, the one that is routing to the remaining vRealize Automation appliance nodes. Select another NIC for management, or manage it directly from the virtual machine management console.

    2. Recover the former master node.

      Power the node on or otherwise correct the issue. For example, you might reset the virtual machine if it is unresponsive.

    3. From a console session as root, stop the vpostgres service.

      service vpostgres stop

    4. Add the former master node back to its original network, the one that is routing to the other vRealize Automation appliance nodes.

    5. From a console session as root, restart the haproxy service.

      service haproxy restart

    6. Log in to the new vRealize Automation appliance master node management interface as root.

    7. Click vRA Settings > Database.

    8. Locate the former master node, and click Reset.

    9. After a successful reset, restart the former master node.

    10. With the former master powered on, verify that the following services are running.

      haproxy
      horizon-workspace
      rabbitmq-server
      vami-lighttp
      vcac-server
      vco-server

    11. Re-add the former master node to the external load balancer.

    Note:

    If a master node that was demoted to replica is still listed as master, you might need to manually re-join it to the cluster to correct the problem.