Posted in: VMware

vPostgres Database useful commands

Command to connect vPostgres : /opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres We can also connect with the vPostgres database using pgAdmin tool : vPostgres configuration related files :- /storage/db/vpostgres/pg_hba.conf – This config file stores the information about the users that can connect to the database. It also stores the info about the information about from where […]

Posted in: VMware

vPostgres service fails to start on vCenter Appliance with FATAL error “bogus data in lock file postmaster.pid” on VCSA

This article helps to get the vPostgres service up if the service is failing to start with FATAL error “bogus data in lock file postmaster.pid” # service-control –start vmware-vpostgres Perform start operation. vmon_profile=None, svc_names=[‘vmware-vpostgres’], include_coreossvcs=False, include_leafossvcs=False 2019-11-06T21:38:14.283Z   Service vmware-vpostgres state STOPPED Error executing start on service vmware-vpostgres. Details {     “resolution”: null,     “detail”: [ […]