ERROR: "permission denied to create extension "pgcrypto"" when atempting to upgrade Cloud Director

Products

• VMware Cloud Director

Issue/Introduction

• Unable to upgrade the database: and getting the following error:

Backup your database now using the tools provided by your database vendor.
Enter [Y] after the backup is complete. Y
Running 5 upgrade tasks
Executing upgrade task:
Successfully ran upgrade task
Executing upgrade task:
Successfully ran upgrade task
Executing upgrade task:
Successfully ran upgrade task
Executing upgrade task:
..........[10]

org.postgresql.util.PSQLException: ERROR: permission denied to create extension "pgcrypto"
Hint: Must have CREATE privilege on current database to create this extension.

Environment

VMware Cloud Director 10.6.1

Cause

This issue is caused by the fact that the owner of the Cloud Director database named "vcloud" is postgres instead of vcloud.

Resolution

This needs database modification. Contact Broadcom Support and note this Article ID (388958) in the problem description.