service-control --start vmware-vsan-health
Operation not cancellable. Please wait for it to finish...Performing start operation on service vsan-health...Error executing start on service vsan-health. Details { "detail": [ { "id": "install.ciscommon.service.failstart", "translatable": "An error occurred while starting service '%(0)s'", "args": [ "vsan-health" ], "localized": "An error occurred while starting service 'vsan-health'" } ], "componentKey": null, "problemId": null, "resolution": null}Service-control failed. Error: { "detail": [ { "id": "install.ciscommon.service.failstart", "translatable": "An error occurred while starting service '%(0)s'", "args": [ "vsan-health" ], "localized": "An error occurred while starting service 'vsan-health'" } ], "componentKey": null, "problemId": null, "resolution": null}The user "vsanhealth" within the /storage/db/vpostgres/pg_hba.conf file is missing.
Edit the pg_hba.conf file to include the missing vsanhealth user.
cp /storage/db/vpostgres/pg_hba.conf /tmp/pg_hba.conf-backupvi storage/db/vpostgres/pg_hba.conf# hba entries for role vsanhealthlocal VCDB vsanhealth peer map=vcdb /opt/vmware/vpostgres/current/bin/psql -U postgres -d VCDB -c "select pg_reload_conf();"service-control --stop --all;service-control --start --allIf VCHA is enabled, it may be required to disable/delete VCHA.
Example of a default /storage/db/vpostgres/pg_hba.conf file:
################################ pg_hba.conf###############################
# hba entries for role vstatsuserlocal VCDB vstatsuser peer
# hba entries for role postgreslocal all postgres peer map=applmgmt
# hba entries for role archiverlocal replication archiver peer map=archiver
# hba entries for role lookupsvc_sync_dblocal VCDB lookupsvc_sync_db peer map=vcdb
# hba entries for role vpxd_svcs_tagginglocal VCDB vpxd_svcs_tagging peer map=vcdb
# hba entries for role vpxd_svcs_computepolicylocal VCDB vpxd_svcs_computepolicy peer map=vcdb
# hba entries for role vpxd_svcs_kv_storelocal VCDB vpxd_svcs_kv_store peer map=vcdb
# hba entries for role vpxdlocal VCDB vpxd peer map=vcdb
# hba entries for role observabilitylocal VCDB observability peer
# hba entries for role trustmanagement_sync_dblocal VCDB trustmanagement_sync_db peer map=vcdb
# hba entries for role vsanhealthlocal VCDB vsanhealth peer map=vcdb
# hba entries for role wcpuserlocal VCDB wcpuser peer map=vcdb
# hba entries for role hdcsuserlocal VCDB hdcsuser peer map=vcdb
# hba entries for role fcduserlocal VCDB fcduser peer map=vcdb
# hba entries for role certmgr_subscriptionlocal VCDB certmgr_subscription peer map=vcdb
# hba entries for role certmgr_syncaaslocal VCDB certmgr_syncaas peer map=vcdb
# hba entries for role clslocal VCDB cls peer map=vcdb
# hba entries for role vlcmuserlocal VCDB vlcmuser peer map=vcdb
# hba entries for role hvclocal VCDB hvc peer map=vcdb
# hba entries for role vumuserlocal VCDB vumuser peer map=updatemgr
# hba entries for role vidm_services_userlocal VCDB vidm_services_user peer map=vcdb
# hba entries for role perfchartsuserlocal VCDB perfchartsuser peer map=vcdb
# hba entries for role alllocal all all scram-sha-256host all all 127.0.0.1/32 scram-sha-256host all all ::1/128 scram-sha-256