vmware-vpxd service fails to start at "StopPending" status.

Products

• VMware vCenter Server

Issue/Introduction

When attempting to start all services, service "vmware-vpxd" stops at "StoppedPending" status.

Running:
 applmgmt lwsmd observability-vapi vmafdd vmcad vmdird vmware-certificateauthority vmware-cis-license vmware-eam vmware-envoy vmware-envoy-hgw vmware-envoy-sidecar vmware-infraprofile vmware-rhttpproxy vmware-sca vmware-stsd vmware-vapi-endpoint vmware-vmon vtsdb
StopPending:
 vmware-vpxd
Stopped:
 lookupsvc observability pschealth vc-ws1a-broker vlcm vmcam vmonapi vmware-analytics vmware-certificatemanagement vmware-content-library vmware-hvc vmware-imagebuilder vmware-netdumper vmware-perfcharts vmware-pod vmware-postgres-archiver vmware-rbd-watchdog vmware-sps vmware-topologysvc vmware-trustmanagement vmware-updatemgr vmware-vcha vmware-vdtc vmware-vpostgres vmware-vpxd-svcs vmware-vsan-health vmware-vsm vsphere-ui vstats wcp

 

From /var/log/vmware/vpxd/vpxd.log, the following error appears.

YYYY-MM-DDTHH:MM:SS.MMMZ error vpxd[XXXXXX] [Originator@XXXX 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: No such file or directory
-->     Is the server running locally and accepting connections on that socket?

From /var/log/vmware/vpostgres/postgresql.log, the following error appears.

YYYY-MM-DD HH:MM:SS.MMM UTC XXXXXXXX.XXXXX 0    XXXXXX 18CONTEXT:  line XX of configuration file "/storage/db/vpostgres/pg_hba.conf"
YYYY-MM-DD HH:MM:SS.MMM UTC XXXXXXXX.XXXXX 0    XXXXXX 19FATAL:  could not load pg_hba.conf
YYYY-MM-DD HH:MM:SS.MMM UTC XXXXXXXX.XXXXX 0    XXXXXX 20LOG:  database system is shut down

 

Cause

Incorrect postgres entry.

Resolution

1. Open a SSH session to vCenter.
2. Back up /storage/db/vpostgres/pg_hba.conf file.

   cp /storage/db/vpostgres/pg_hba.conf  /storage/db/vpostgres/pg_hba.conf.bak

3. Open /storage/db/vpostgres/pg_hba.conf file.

   vi /storage/db/vpostgres/pg_hba.conf

4. Change vpxd entry to this at line XX showed in postgresql.log.

   # hba entries for role vpxd
   local        VCDB            vpxd                            peer map=vcdb

5. Start all services. Services should be able to start normally now.