7.4

Table Of Contents
PostgreSQL Database Upgrade Merge Does Not Succeed
The external PostgreSQL database merge with the embedded PostgreSQL database does not succeed.
Problem
If the PostgreSQL database upgrade merge does not succeed, you can perform a manual merge.
Solution
1 Revert the vRealize Automation virtual appliance to the snapshot you made before upgrade.
2 Log in to the vRealize Automation virtual appliance and run this command to allow upgrade to
complete if the database merge does not succeed.
touch /tmp/allow-external-db
The command does not disable auto merge.
3 On the remote PostgreSQL database host, connect to the PostgreSQL database using the psql tool
and run these commands.
CREATE EXTENSION IF NOT EXISTS "hstore";
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
CREATE SCHEMA saas AUTHORIZATION vcac;
The user in this command is vcac. If vRealize Automation connects to the external database with a
different 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
Replica vRealize Automation Appliance Fails to Update
Replica vRealize Automation appliance fails to update during master appliance update.
Upgrading from vRealize Automation 7.1 or Later to 7.4
VMware, Inc. 67