Use this procedure to restore 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. Delete vro-config.zip from the /tmp directory.
    rm -rf /tmp/vro-config.zip
  2. Revoke vco_migration user remote access to the vcac database by removing the previously added line from the source PostgreSQL client authentication configuration file.
    sed -i '/vro_migration/d' /storage/db/pgdata/pg_hba.conf
  3. Restart the PostgreSQL server.
    service vpostgres restart
  4. Delete vro_migration user from the source PostgreSQL database.
    1. Revoke vro_migration user access to the tables in the vcac database.
      sudo -u postgres -i -- /opt/vmware/vpostgres/current/bin/psql vcac -c "REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA public FROM vro_migration;"
    2. Remove vro_migration user from the source PostgreSQL server.
      sudo -u postgres -i -- /opt/vmware/vpostgres/current/bin/psql vcac -c "DROP USER vro_migration;"