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;