7.1

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..'
service ${psql_service} stop > /dev/null
service ${psql_service} start
echo 'restart_psql finished'
}
EOF
(3)
chmod 700 /etc/bootstrap/preupdate.d/00-00-00-fix-psql-restart
Backup Copies of .xml Files Cause the System to Time Out
vRealize Automation registers any le with an .xml extension in
the \VMware\vCAC\Server\ExternalWorkows\xmldb\ directory. If this directory contains backup les
with an .xml extension, the system runs duplicate workows that cause the system to time out.
Solution
Workaround: When you back up les in this directory, move the backups to another directory, or change the
extension of the backup le name to something other than .xml.
Chapter 8 Troubleshooting the Upgrade
VMware, Inc. 45