After you configure the vCloud Automation Center Appliance for use as a dedicated PostgreSQL database, you change the password for the database owner.

1

Log in to the PostgreSQL server with administrator-level privileges.

2

From a command prompt, change the user account to postgres.

su postgres

3

Open an SQLshell (psql) session.

4

Navigate to /opt/vmware/vpostgres/9.2/bin/psql.

5

Run the following command to update the password for the database user.

 
ALTER USER vcac ENCRYPTED PASSWORD 'mypassword';

In this example, the database owner is a user named vcac and the password is set to mypassword. Replace these values with the values that are appropriate to your environment.

6

Log out of the PostgreSQL server.

\q

Configure the lead vCloud Automation Center Appliance for your cluster and set it to use your standalone PostgreSQL Database. See Configure the Primary vCloud Automation Center Appliance.