After you upgrade the VMware Cloud Director appliance to version 10.4.1 or later, you can change the PostgreSQL password manually to a custom password with at least 14 characters.
- Log in directly or by using an SSH client to the primary appliance console as root.
- Switch to the PostgreSQL database.
- Connect to the PostgreSQL and vCloud databases.
- To change the password in the database, use the
ALTER USER vcloud WITH PASSWORD '14_character_mininum_password';
- Exit from psql and the PostgreSQL session back to root.
- To change the database user name and password, from the primary appliance, run the following cell management tool command.
/opt/vmware/vcloud-director/bin/cell-management-tool reconfigure-database -dbpassword 'same_password_used_in_ALTER_command' \ -dbuser vcloud -private-key-path /opt/vmware/vcloud-director/id_rsa --remote-sudo-user=postgres -i $(service vmware-vcd pid cell)The command propagates the changes to each appliance in the cluster.
What to do next
For more information on modifying the database properties, see Updating the Database Connection Properties.