Symptoms
Accessing the Update Manager/vSphere Lifecycle Manager (vLCM) Database fails with FATAL: Peer authentication failed for user "vumuser"/var/log/vmware/vpostgres/postgresql-xx.log
2023-05-22 20:44:03.228 UTC 646bd413.5511 0 [unknown] [unknown] [local] 21777 1 LOG: connection received: host=[local]2023-05-22 20:44:03.229 UTC 646bd413.5511 0 VCDB vumuser [local] 21777 2 LOG: no match in usermap "updatemgr" for user "vumuser" authenticated as "root"2023-05-22 20:44:03.229 UTC 646bd413.5511 0 VCDB vumuser [local] 21777 3 FATAL: Peer authentication failed for user "vumuser"2023-05-22 20:44:03.229 UTC 646bd413.5511 0 VCDB vumuser [local] 21777 4 DETAIL: Connection matched pg_hba.conf line 54: "local VCDB vumuser peer map=updatemgr"
Note: The preceding log excerpts are only examples. Date, time, and environmental variables may vary depending on your environment.
Resolution
In order to access vLCM database, refer to the below steps
Log in to the vCenter Server via sshSwitch the user to updatemgr from root
su updatemgr -s /bin/bashNote: 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 enterTo switch back to root, type exit and hit enter
Screenshot for reference:
