Configure an appliance database on the designated secondary vRealize Appliance.

About this task

For related information, see the following content:

  • Add a New Hard Disk to a Virtual Machine in vSphere Web Client in vSphere product documentation

  • Gracefully Shutting Down a Windows Guest When the Virtual Machine Powers Off (1744) in the VMware Knowledge Base.


  • Create DNS entry, for example: dbCluster.domain.local

  • IP address allocated for load balancer.

  • An installed vRealize Appliance freshly deployed and resolvable through DNS.

  • The user configuring the Appliance Database must have Administrator access to vSphere in order to add new disks to the vRealize Appliances.

  • Download the file from the VMware Knowledge Base.

    The link is if you need to paste it into a browser.


  1. Perform a graceful shutdown of the target appliance using shut down guest in the VMware vCenter Server™.
  2. Add a 20 GB disk to the virtual appliance by using the VMware vCenter Server™.
  3. Power on the appliance.
  4. Verify that SSH is enabled on the virtual appliance.
    1. Log in to the Virtual Appliance Management Interface at https://appliance_IP:5480.
    2. Click the Admin tab.
    3. Ensure that the SSH service enabled and Administrator SSH login enabled check boxes are selected.
    4. Click Save Settings.
  5. Unzip the file that you downloaded from the VMware Knowledge Base and copy the 2108923_dbCluster.tar file to the appliance.
  6. Extract the and files using the tar xvf 2108923_dbCluster.tar command.
    # tar xvf 2108923_dbCluster.tar
  7. Locate the disk you added using the parted -l command.

    For a fresh vRealize Automation deployment, the disk name should be /dev/sdd. The name differs depending on the original version of vRealize Automation deployed.

    # parted -l
    Error: /dev/sdd: unrecognized disk label
    Sector size (logical/physical): 512B/512B

  8. Configure the disk using the ./ disk name command.

    For a vRealize Automation deployment, the exact command is ./ /dev/sdd.

    # ./ /dev/sdd
    Ownership changed successfully
    WAL Archive disk configured successfully

  9. Run the script using the following command.

    / [-d] <db_fqdn> [-D] <db_vip> [-w] <db_pass> [-r] <replication_password> [-p] <postgres_password>

    Replace the parameters with the following values as appropriate for your system.




    Database load balancer FQDN


    Database virtual IP address. Optional, will create /etc/hosts entry.


    Sets the database password to the specified entry.


    Replication password. Optional, will use the database password if not set.


    Postgres password. Optional, will use database password if not set.

    For example, ./ -d pgCluster.domain.local -w changeMe1! -r changeMe1! -p changeMe1!


    Update the password from ChangeMe! to one that is appropriate for your system. Also, if you are using a load balancer virtual IP, specify the -D parameter using the IP address of the virtual IP.

    # ./ -d dbCluster.domain.local -w changeMe1! -r changeMe1! -p changeMe1!
    Updating vRealize Automation to utilize database cluster fully qualified domain name