Symptoms:
Checking the vRSLCM VM Console we see the postgres service failing to start
Similar errors in domainmanager.log:
journalctl -xe command in vRSLCM appliance will have the below errors.
Sep 01 01:27:44 vRSLCM.domain.com systemd[1]: Starting VMware Postgres database server...
Sep 01 01:27:44 vRSLCM.domain.com postgres[9517]: pg_ctl: could not open PID file "/var/vmware/vpostgres/current/pgdata/postmaster.pid": Permission denied
Sep 01 01:27:44 vRSLCM.domain.com systemd[1]: vpostgres.service: Control process exited, code=exited status=1
Sep 01 01:27:44 vRSLCM.domain.com systemd[1]: vpostgres.service: Failed with result 'exit-code'.
Sep 01 01:27:44 vRSLCM.domain.com systemd[1]: Failed to start VMware Postgres database server.
Sep 01 01:27:44 vRSLCM.domain.com systemd[1]: vpostgres.service: Service RestartSec=100ms expired, scheduling restart.
Sep 01 01:27:44 vRSLCM.domain.com systemd[1]: vpostgres.service: Scheduled restart job, restart counter is at 5.
Sep 01 01:27:44 vRSLCM.domain.com systemd[1]: Stopped VMware Postgres database server.
Sep 01 01:27:44 vRSLCM.domain.com systemd[1]: vpostgres.service: Start request repeated too quickly.
Sep 01 01:27:44 vRSLCM.domain.com systemd[1]: vpostgres.service: Failed with result 'exit-code'.
Sep 01 01:27:44 vRSLCM.domain.com systemd[1]: Failed to start VMware Postgres database server.
rm -rf /storage/db/pgdata/
/etc/bootstrap/firstboot.d/02-configure-postgres.sh
/etc/bootstrap/firstboot.d/20-start-services
service vlcm-service start