Test failover functionality from the primary appliance database machine to the secondary machine.

About this task

For this test, the appliance database is failed over, and the replica database on the secondary appliance becomes the master database.

Prerequisites

The appliance database is installed and configured on primary and secondary vRealize Appliances as described in vRealize Automation Installation and Configuration.

Procedure

  1. Log in to your primary, or master, appliance as root using SSH.
  2. Stop the vpostgres service using the service vpostgres stop command.

    A message similar to the following appears.

    # service vpostgres stop
    Stopping VMware vPostgres: Last login: Mon Apr 27 19:49:26 UTC 2015 on pts/0
    ok

  3. Log in to the secondary appliance as root using SSH.
  4. Run the /opt/vmware/vpostgres/current/share/promote_replica_to_primary command as the postgres user to promote the replica database to master.
    su - postgres
    /opt/vmware/vpostgres/current/share/promote_replica_to_primary
    server promoting
    Note:

    After running this command, the replica database on the secondary appliance becomes the master. The appliance database on the original primary appliance does not become an actual replica until you run the run_as_replica command.

  5. Log in to the targeted replica appliance machine as root using SSH.
  6. Configure replication using the following command.

    ./run_as_replica -h master database appliance -b -W -U replicate

    Replace the parameters with the following values.

    Option

    Value

    [-h]

    Host name of the master database server. Port 5432 is assumed.

    [-b]

    Take a base backup from the master. This option destroys the current contents of the data directory.

    [-W]

    Prompt for the password of the user performing the replication.

    [-U]

    The user performing the replication. Generally this user is replicate.

    For example:

    # su - postgres  
    /opt/vmware/vpostgres/current/share/run_as_replica -h app2.domain.local -b -W -U replicate

  7. Enter the replicate user password when prompted.
  8. Type "yes" after verifying the thumb print of the primary machine when prompted.
  9. Enter the postgres user password when prompted.
  10. Type "yes" in response to the following message.

    "WARNING: the base backup operation will replace the current contents of the data directory. Please confirm by typing yes."

What to do next

Validate that the replication was successful. See Validate Appliance Database Replication.