PostgreSQL databases have specific configuration requirements when you use them with vCloud Director. Install and configure a database instance and create the vCloud Director database user account before you install vCloud Director.

Prerequisites

You must be familiar with PostgreSQL commands, scripting, and operation.

Procedure

  1. Configure the database server.
    A database server configured with 16GB of memory, 100GB storage, and 4 CPUs should be adequate for most vCloud Director server groups.
  2. Install a supported distribution of PostgreSQL on the database server.
    • The SERVER_ENCODING value of the database must be UTF-8. This value is established when you install the database and always matches the encoding used by the database server operating system.
    • Use the PostgreSQL initdb command to set the value of LC_COLLATE and LC_CTYPE to en_US.UTF-8. For example: 
      initdb --locale=en_US.UTF-8
  3. Create the database instance and give it an owner.
    Use a command like this one to specify a database user named vcloud as the database owner. 
    create database vcloud owner vcloud;
  4. Assign a database password to the database owner account.
    The following command assigns the password vcloudpass to database owner vcloud. 
    alter user vcloud password 'vcloudpass';
  5. Enable the database owner to log in to the database.
    The following command assigns the login option to database owner vcloud. 
    alter role vcloud with login;

What to do next

For additional configuration suggestions, see VMware Knowledge Base article https://kb.vmware.com/kb/2151464.