7.0

3 In the Address text box, edit the vRealize Orchestrator endpoint URL to remove :8281.
4 Click OK.
5 Manually start data collection on the vRealize Orchestrator, and verify that the collection is
successful.
Configure an External PostgreSQL Database to Merge into an
Embedded PostgreSQL Environment
After you upgrade the master node in the vRealize Automation appliance you can optionally configure the
external PostgreSQL database to merge into an embedded PostgreSQL master node.
This is the last task in the upgrade process. You can perform this task anytime after upgrade is finished.
This task is not required if it is not applicable to your deployment environment.
Prerequisites
Verify that the master node in the vRealize Automation appliance is upgraded.
Procedure
1 Select your master vRealize Automation appliance as described in the knowledge base article at
http://kb.vmware.com/kb/2105809.
2 Use SSH to log in to the primary virtual appliance.
3 Navigate to the /etc/vcac/server.xml file and make the following changes so that the PostgreSQL
database connection specifies the external IP address of the master PostgreSQL node. Change the
URL attribute from url=jdbc:postgresql://EXT_DB_FQDN:EXT_DB_PORT/EXT_DB_NAME?
sslmode=require to url=jdbc:postgresql://EXT_DB_IP:EXT_DB_PORT/EXT_DB_NAME.
n
EXT_DB_FDN is the Fully Qualified Domain Name of the external vRealize Automation database.
n
EXT_DB_PORT is the external database port number.
n
EXT_DB_IP is the IP address of the external vRealize Automation database master node.
n
EXT_DB_NAME is the vRealize Automation external database name.
Be sure to remove ?sslmode=require.
4 Open a command-line prompt and run the following command to check the vPostgreSQL service
status.
service vpostgres status
If the service is stopped, run the service vpostgres start command.
5 Run the merge command.
vcac-vami db-merge-external
Upgrading from vRealize Automation 6.2 to 7.0.1
VMware, Inc. 48