PostgreSQL databases have specific configuration requirements when you use them with vCloud Director. Before you install vCloud Director, you must install and configure a database instance and create the vCloud Director database user account.
You must be familiar with PostgreSQL commands, scripting, and operation.
- Configure the database server.
A database server with 16 GB of memory, 100 GB storage, and 4 CPUs is appropriate for typical vCloud Director server groups.
- Install a supported distribution of PostgreSQL on the database server.
SERVER_ENCODINGvalue 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
en_US.UTF-8. For example:
- Create the database user.
The following command creates the user
create user vcloud;
- Create the database instance and give it an owner.
Use a command like this one to specify a database user named
vcloudas the database owner.
create database vcloud owner vcloud;
- Assign a database password to the database owner account.
The following command assigns the password
vcloudpassto database owner
alter user vcloud password 'vcloudpass';
- Enable the database owner to log in to the database.
The following command assigns the
loginoption to database owner
alter role vcloud with login;
What to do next
After creating your vCloud Director server group, you can configure the PostgreSQL database to require SSL connections from the vCloud Director cells and adjust some database parameters for optimal performance. See Perform Additional Configurations on the PostgreSQL Database.