OPERATIONAL DEFECT DATABASE
...
...
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.
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:
Click on a version to see all relevant bugs
VMware Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.
