Access vPostgres

When you install a vCenter Server Appliance (vCSA) you are not requested to define a password for vPostgres and the DBMS is installed with a random password for postgres user that you don't know.

There are 2 solutions:

1) grab it from C:\Windows\System32\config\systemprofile\AppData\Roaming\postgresql\pgpass.conf

2) reset it using the following procedure:
- Add the following line to D:\ProgramData\VMware\vCenterServer\data\vpostgres\pg_hba.conf
(host all    all trust)
- Reload the service parameters using this command: "D:\Program Files\VMware\vCenter Server\vPostgres\bin\pg_ctl.exe" reload  -D "D:/ProgramData/VMware/vCenterServer/data/vpostgres"
- Connect without any password psql -h localhost -U postgres
Tags: , , ,

About author

Vittorio Pavesi