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

  • For a minimal deployment, log in using SSH to the source vRealize Automation appliance as root.

  • 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.
    1. 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';"
      
    2. 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

What to do next

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