7.4

Table Of Contents
c Append a line to the /var/vmware/vpostgres/current/pgdata/pg_hba.conf file.
host all all vra-va-ip-address/32 md5
Note The pg_hba.conf file requires using a CIDR prefix format instead on an IP address and a
subnet mask.
d Restart the PostgreSQL server service.
service vpostgres restart
4 Migrate the database to the internal PostgreSQL database, by running the vro-configure script with
the db-migrate command.
./vro-configure.sh db-migrate --sourceJdbcUrl JDBC_connection_URL --sourceDbUsername database_user
--sourceDbPassword database_user_password
Note Enclose passwords that contain special characters in single quotation marks.
The JDBC_connection_URL depends on the type of database that you use.
PostgreSQL: jdbc:postgresql://host:port/database_name
MSSQL: jdbc:jtds:sqlserver://host:port/database_name\; if using SQL authentication and MSSQL:
jdbc:jtds:sqlserver://host:port/database_name\;domain=domain\;useNTLMv2=TRUE if using Windows
authentication.
Oracle: jdbc:oracle:thin:@host:port:database_name
The default database login information is:
database_name vmware
database_user vmware
database_user_password vmware
5 Remove all certificates from the database keystore.
./vro-configuration.sh untrust --reset-db
6 Reinstall the Orchestrator plug-ins.
a Log in to Control Center as root.
b Click Troubleshooting.
c Click Force plug-ins reinstall.
7 Start the Orchestrator server service.
Upgrading from vRealize Automation 7.1 or Later to 7.4
VMware, Inc. 37