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.

Prerequisites

  • 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 2108923_dbCluster.zip file from the VMware Knowledge Base.

    The link is http://kb.vmware.com/selfservice/microsites/search.do?cmd=displayKC&docType=kc&externalId=2108923 if you need to paste it into a browser.

Procedure

  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 2108923_dbCluster.zip file that you downloaded from the VMware Knowledge Base and copy the 2108923_dbCluster.tar file to the appliance.
  6. Extract the configureDisk.sh and pgClusterSetup.sh files using the tar xvf 2108923_dbCluster.tar command.
    # tar xvf 2108923_dbCluster.tar
    configureDisk.sh
    pgClusterSetup.sh
  7. Locate the disk you added using the parted -l command.
    Note:

    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 ./configureDisk.sh disk name command.

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

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

  9. Run the pgClusterSetup.sh script using the following command.

    /pgClusterSetup.sh [-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.

    Option

    Value

    [-d]

    Database load balancer FQDN

    [-D]

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

    [-w]

    Sets the database password to the specified entry.

    [-r]

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

    [-p]

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

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

    Note:

    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.

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