vCenter update fails with password authentication failed for user "vpxd"

Products

• VMware vSphere ESXi

Issue/Introduction

Applying VMware vCenter Server 8.0 Update 2d fails

• The following error is received:
  
  Exception occured in postInstallHook for B2B-patching. Please check the logs for more details. Take corrective action and then resume.


• The following logs are found in vCenter: /var/log/vmware/vpostgres/vpostgresql.log

2024-06-21 15:47:51.536 UTC 6675a0a7.118b81 0 VCDB vpxd [local] 1149825 4LOG:  could not send data to client: Broken pipe
2024-06-21 15:47:51.539 UTC 6675a0a7.118b82 0 [unknown] [unknown] [local] 1149826 1LOG:  connection received: host=[local]
2024-06-21 15:47:51.540 UTC 6675a0a7.118b82 0 VCDB vpxd [local] 1149826 2FATAL:  password authentication failed for user "vpxd"
2024-06-21 15:47:51.540 UTC 6675a0a7.118b82 0 VCDB vpxd [local] 1149826 3DETAIL:  User "vpxd" has no password assigned.
Connection matched pg_hba.conf line 27: "local        all             all                             scram-sha-256"


• The vCenter: /var/log/vmware/vpxd/vpxd.log has the following message:
  
  2024-06-21T11:56:04.211-04:00 error vpxd[1112667] [Originator@6876 sub=vpxdVdb] [VpxdVdb::SetDBType] Failed to connect to database: ODBC error: (08001) - [unixODBC]connection to server on socket "/var/run/vpostgres/.s.PGSQL.5432" failed: fe_sendauth: no password supplied

Resolution

1. Add the following line at the end of the following file:
   
   File
   
   vCenter:  /storage/db/vpostgres/pg_hba.conf

Line:
   
   host         all             all             0.0.0.0/0       trust


2. After the upgrade, remove the above line from the file /storage/db/vpostgres/pg_hba.conf file.