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

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

Resolution

• VMware Engineering is aware of this issue.
  
  
• Workaround: To access DB, execute the following command:
  
  root@sddc_ManagerFQDN [ ~ ]# /usr/pgsql/13/bin/psql -h localhost -U postgres