Configure an Appliance Database on both the designated primary and secondary vRealize Appliances.

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.

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 -1 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 -1
    ...
    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:

    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!
    ...
    11.) Updating vRealize Automation to utilize database cluster fully qualified domain name
    Finished
    

  10. Update the password from ChangeMe! to one that is appropriate for your system.

What to do next

Configure Appliance Database Replication on the Secondary Appliance.