Use this procedure to restore the configuration of the source VMware vRealize ™ Automation appliance.

Prerequisites

  • 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. Run this command to delete vro-config.zip from the /tmp directory.
    rm -rf /tmp/vro-config.zip
  2. Run this command to 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. Run this command to restart the PostgreSQL server.
    service vpostgres restart
  4. Delete vro_migration user from the source PostgreSQL database.
    1. Run this command to 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. Run this command to 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;"