7.3

Table Of Contents
Temporarily Change the Configuration of the Source
vRealize Automation Appliance
Before you migrate the vRealize Orchestrator server from your vRealize Automation 7.x source
environment to vRealize Automation 7.3, you must run the commands in this procedure to temporarily
change the configuration of the source vRealize Automation appliance.
Prerequisites
n
For a minimal deployment, log in using SSH to the source vRealize Automation appliance as root.
n
For a high-availability deployment, log in using SSH to the master source vRealize Automation
appliance as root.
Procedure
1 Create a vro_migration user in the source PostgreSQL server.
a Before you run the command, replace VRO-MIGRATION-USER-PASSWORD with a password for
the vro_migration user .
sudo -u postgres -i -- /opt/vmware/vpostgres/current/bin/psql vcac
-c "CREATE USER vro_migration WITH PASSWORD
'VRO-MIGRATION-USER-PASSWORD';"
b Grant the vro_migration user access to the tables in the vcac database.
sudo -u postgres -i -- /opt/vmware/vpostgres/current/bin/psql vcac
-c "GRANT SELECT ON ALL TABLES IN SCHEMA public TO vro_migration;"
2 Create a backup of the source PostgreSQL client authentication configuration file
at /storage/db/pgdata/pg_hba.conf.
cp /storage/db/pgdata/pg_hba.conf /storage/db/pgdata/pg_hba.conf.bak
3 Modify the source PostgreSQL client authentication configuration file to grant vro_migration user
remote access to vcac database from the target vRealize Automation appliance. Before you run the
command, replace TARGET-VRA-APPLIANCE-IPV4-ADDRESS with the IP v4 address of the target
vRealize Automation appliance.
echo "host vcac vro_migration TARGET-VRA-APPLIANCE-IPV4-ADDRESS/32 md5"
>> /storage/db/pgdata/pg_hba.conf
4 Restart the source PostgreSQL server.
service vpostgres restart
Migrating vRealize Automation to 7.3 or 7.3.1
VMware, Inc. 48