7.1

The user in this command is vcac. If vRealize Automation connects to the external database with a
dierent user, replace vcac in this command with the name of that user.
CREATE EXTENSION IF NOT EXISTS "citext" SCHEMA saas;
4 Run upgrade.
If upgrade is successful, the system works as expected with the external PostgreSQL database. Ensure
that the external PostgreSQL database is running properly.
5 Log in to the vRealize Automation virtual appliance and run these commands
/etc/bootstrap/postupdate.d/00-20-db-merge-external
/etc/bootstrap/postupdate.d/11-db-merge-external
Upgrade Fails to Upgrade the Management Agent or Certificate Not Installed on
a IaaS Node
Management Agent or Certicate is not upgraded on a IaaS node and error message appears in the
management console.
Problem
If the upgrade fails to upgrade on a IaaS node and error messages about the Management Agent or
Certicate appear in the management console, use these suggestions to troubleshoot the problem.
n
Check the Management Agent log on the aected node for errors.
n
Check if the Management Agent was auto-upgraded by examining the version number in Programs
and Features.
n
If the Management Agent is upgraded, ensure that its service is running.
n
If the Management Agent is upgraded and running, restart upgrade on the virtual appliance.
n
If the Management Agent is not upgraded, perform a manual upgrade of the Management Agent. Open
a browser and navigate to the VMware vRealize Automation IaaS Installation page on the vRealize
Automation appliance at hps://virtual_appliance_host:5480/installer. Download and run the
Management Agent Installer. Restart upgrade on the virtual appliance.
Bad PostgreSQL Service State Stops Upgrade and Displays Error Message
The postupgrade scripts cause an intermient problem when vpostgres service returns incorrect status.
Problem
When the vpostgres service reports being in a bad state, upgrade fails at the /etc/bootstrap/postupdate.d/10-
postgres postupgrade script. When your upgrade fails on /etc/bootstrap/preupdate.d/10-postgres script
execution, run these three scripts, one at a time, in the following order, and restart upgrade.
(1)
rm -rf /storage/db/psql-upgrade
(2)
cat > /etc/bootstrap/preupdate.d/00-00-00-fix-psql-restart << "EOF"
#!/bin/sh
cat >> /usr/lib/vmware-bootstrap-vrva-base/psql.inc << "EOF"
function psql_restart () {
echo 'Restarting PostgreSQL server..'
Upgrading from vRealize Automation 6.2 to 7.1
50 VMware, Inc.