Attempt to connect to SDDC Manager postgres Fails with password authentication error

Products

• VMware SDDC Manager

Issue/Introduction

Symptoms:

• Running psql -h localhost -U postgres command from SDDC Manager from root directory failed with errors similar to the excerpt below:
  
       root@sddc_ManagerFQDN [ ~ ]# psql -h localhost -U postgres
     psql: error: connection to server at "localhost" (127.0.0.1), port 5432 failed: fe_sendauth: error sending password authentication.

Environment

VMware Cloud Foundation 5.1.x

Cause

In VCF 5.1.x, psql command would not work on SDDC Manager.

Resolution

• Issue is resolved in VCF version 5.2.x and above.
  
  
• Workaround: To access DB in VCF 5.1.x, execute the following command instead:
  
  root@sddc_ManagerFQDN [ ~ ]# /usr/pgsql/13/bin/psql -h localhost -U postgres