vpostgres on windows

This runs as a service account

NT SERVICE\vPostgres

You can start it using

C:\Program Files\VMware\vCenter Server\bin>service-control –start vPostgres

C:\Program Files\VMware\vCenter Server\bin>service-control –stop vPostgres

You cannot start it using pg_ctl as administrator

If there are errors starting you can see the postgresql*.logs

normally in C:\ProgramData\VMware\vCenterServer\logs\vpostgres

If nothing here check the windows events log

Go check the Application log: right
click on Computer -> Manage -> Events -> Application

You can increase logging editing the postgresql.conf file

normally found in C:\ProgramData\VMware\vCenterServer\data\vpostgres

track_activities = on
track_activity_query_size = 6000
log_statement_stats = on
log_statement = ‘all’

In a case I had the reverse proxy server had to be restarted to allow the vpostgres service to start.


If you need to work around unknown passwords you can lower security so a password isn’t required

Search for the C:\ProgramData\VMware\vCenterServer\data\vpostgres\pg_hba.conf

change md5 to trust

To run pg_ctl you’#ll have to  be postgres user. Run command prompt at postgres user

C:\Program Files\VMware\vCenter Server\vPostgres\bin>psql.exe -U vc -d VCDB
psql (9.4.9 (VMware Postgres release))


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s