Error. "function gen_random_uuid() does not exist" updating VCD 10.5.1 to 10.6.1.1

Products

• VMware Cloud Director

Issue/Introduction

• You are running a Linux based installation of VCD (VMware Cloud Director) with an external PostgreSQL server
• Trying to update the cells from VCD version 10.5.x to 10.6.x you get an error on /opt/vmware/vcloud-director/bin/upgrade in the VCD cell like the following:
  
  Unable to upgrade the database: org.postgresql.util.PSQLException: ERROR: function gen_random_uuid() does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Position: 257

Environment

VMware Cloud Director 10.5.x

Cause

This issue occurs because the version of PostgreSQL running on the external server is bellow version 13. Upgrading and administration of the external PostgreSQL database instance is outside the scope of Broadcom Support.

Resolution

Update the external PostgreSQL server to at least version 13 and retry the upgrade.

Additional Information

For further information on VCD 10.6 you can visit VMware Cloud Director 10.6 Release Notes