Accessing the vSphere Lifecycle Manager Database using vumuser fails with FATAL: Peer authentication failed for user "vumuser"

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• Accessing the Update Manager/vSphere Lifecycle Manager (vLCM) Database over SSH fails with FATAL:  Peer authentication failed for user "vumuser"
• In the /var/log/vmware/vpostgres/postgresql-xx.log on vCenter Server, entries similar to below are observed

YYYY-MM-DD hh:mm:ss.228 UTC 646bd413.5511 0 [unknown] [unknown] [local] 21777 1 LOG: connection received: host=[local]
YYYY-MM-DD hh:mm:ss.229 UTC 646bd413.5511 0 VCDB vumuser [local] 21777 2 LOG: no match in usermap "updatemgr" for user "vumuser" authenticated as "root"
YYYY-MM-DD hh:mm:ss.229 UTC 646bd413.5511 0 VCDB vumuser [local] 21777 3 FATAL: Peer authentication failed for user "vumuser"
YYYY-MM-DD hh:mm:ss.229 UTC 646bd413.5511 0 VCDB vumuser [local] 21777 4 DETAIL: Connection matched pg_hba.conf line 54: "local VCDB vumuser peer map=updatemgr"

Environment

VMware vCenter Server 8.0.x

Resolution

In order to access vLCM database, refer to the below steps

• Log in to the vCenter Server via ssh
• Switch the user to updatemgr from root

su updatemgr -s /bin/bash

Note: The session would change to updatemgr@<vcenter name> from root@<vcenter name>

• Log in to the database instance

psql -U vumuser -d VCDB

• Exit the database prompt by typing \q and hit enter
• To switch back to root, type exit and hit enter

Screenshot for reference: