6.2

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 Chapter 4 Validate Appliance Database Replication.
Test Appliance Database Failback
Test that failback from the secondary appliance database machine to the primary machine functions.
System Administration
VMware, Inc. 28