Before you migrate the VMware vRealize ™ Orchestrator ™ server from your VMware vRealize ™ Automation 7.2 source environment to vRealize Automation 7.3, you must temporarily change the configuration of the source vRealize Automation appliance.

Before you begin

  • For a minimal deployment, open an SSH console session to the source vRealize Automation appliance as root user.

  • For a high-availability deployment, open an SSH console session to the master source vRealize Automation appliance as root user.

Procedure

  1. Create a vro_migration user.
    1. Run this command to create a vro_migration user in the source PostgreSQL server. Before you run the command, replace {VRO-MIGRATION-USER-PASSWORD} with the vro_migration user password.
      sudo -u postgres -i -- /opt/vmware/vpostgres/current/bin/psql vcac
      -c "CREATE USER vro_migration WITH PASSWORD
      '{VRO-MIGRATION-USER-PASSWORD}';"
      
    2. Run this command to 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. Run this command to 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. Run this command to 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. Run this command to restart the source PostgreSQL server.
    service vpostgres restart

What to do next

Export the Configuration from the Embedded vRealize Orchestrator on the Source vRealize Automation Appliance