6.2

Table Of Contents
Perform an Appliance Database
Failover 3
If your designated primary Appliance Database fails, implement a failover to the designated replica
database on the secondary appliance to maintain system operation.
Prerequisites
Configure the Appliance Database as applicable for your system configuration. See Chapter 2 Configure
the vRealize Automation Appliance Database.
Procedure
1 If possible, log in to the appliance hosting the primary Appliance Database as root using SSH.
If the appliance or its host machine is not running, skip to step 3.
2 Stop the vpostgres service using the service postgres stop command.
# service postgres stop
Stopping Vmware vPostgres: Last login: Mon Apr 27 19:49:26 UTC 2015 on pts/0
ok
3 Promote the replica database on the secondary appliance to be the primary database.
a Log in the secondary appliance as root using SSH.
b Promote the replica database to master as the postrgres user using
the /opt/vmware/vpostgres/current/share/promote_replica_to_primary command.
# su - postgres
/opt/vmware/vpostgres/current/share/promote_replica_to_primary
server promoting
VMware, Inc.
30