6.2

Table Of Contents
For example, ./pgClusterSetup.sh -d pgCluster.domain.local -w changeMe1! -r
changeMe1! -p changeMe1!
Note Update the password from ChangeMe! to one that is appropriate for your system. Also, if you
are using a load balancer virtual IP, specify the -D parameter using the IP address of the virtual IP.
# ./pgClusterSetup.sh -d dbCluster.domain.local -w changeMe1! -r changeMe1! -p changeMe1!
...
Updating vRealize Automation to utilize database cluster fully qualified domain name
Finished
Configure Appliance Database Replication on the Secondary Appliance
Configure the secondary or failover virtual appliance to support appliance database replication.
Set up database replication on the designated secondary appliance so that the appliance database on the
primary appliance is replicated on the secondary appliance in the case of failover.
Prerequisites
The appliance database is installed and configured as described in vRealize Automation Installation and
Configuration.
Procedure
1 Log in to the virtual appliance as root using SSH with the su - postgres command.
2 Configure replication as the postgres user using the following command.
./run_as_replica -h <Primary Appliance> -b -W -U replicate
Replace the parameters with the following values.
Option Value
[-h] Hostname 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 app1.domain.local -b -W -U replicate
3 Enter the replicate user password when prompted.
4 Type "yes" after verifying the thumb print of the primary machine when prompted.
5 Enter the postgres user password when prompted.
Installation and Configuration
VMware, Inc. 78