Increase the Capacity of the Embedded PostgreSQL Database on a VMware Cloud Director Appliance

If you have insufficient space on the PostgreSQL database disk of a VMware Cloud Director appliance, you can increase the capacity of the embedded PostgreSQL database.

The PostgreSQL database resides on Hard disk 3. It has a default size of 80 GB. The procedure can be done while the appliances are operational.

Important: You must increase the capacity of any existing standby appliances before increasing the capacity of the primary appliance.

The PostgreSQL Database disk size on each standby appliance must be the same as the PostgreSQL database disk on the primary appliance.

Prerequisites

• If your VMware Cloud Director environment has standby nodes, identify the standby nodes and the primary node, and begin the procedure from a standby node. For more information on identifying the roles of the nodes, see View the VMware Cloud Director Appliance Cluster Health and Failover Mode.
• If your VMware Cloud Director environment consists of only a primary node, run the procedure on the primary node.

Procedure

1. Log in to the vSphere Client to increase the capacity of Hard Disk 3 to the size that you want.
   The PostgreSQL database disk size on each standby appliance must be as large as the PostgreSQL database disk on the primary appliance.
   1. Select the appliance virtual machine that you want to change.
   2. Select Actions > Edit Settings.
   3. Increase the size of Hard disk 3 and click OK.
   The progress of the reconfiguration task appears in the Recent tasks pane.
2. Apply the changes to the OS of the appliance node.
   1. Log in directly or by using an SSH client to the VMware Cloud Director appliance console as root.
   2. To apply the hard disk resizing change to the OS, run the following script.

      /opt/vmware/appliance/bin/db_diskresize.sh

3. If your environment does not consist of only one primary appliance, repeat the procedure for each of the nodes that has a database.