Please follow the steps below to correct or re-create pgpass.conf file.
• Check if pgpass.conf is available underC:\Windows\System32\config\systemprofile\AppData\Roaming\postgresql.
• If the file is not there, then we need to re-create the file. But for that we need to get the postgres password.
• To reset the postgres password, follow the steps below.
Edit pg_hba config file under C:\ProgramData\VMware\vCenterServer\data\vpostgres and change the md5 to trust (we need to do this since we cannot reset the postgres password on vPostgres DB as we connect to the VCDB as vcuser which is not a super user)
# TYPE DATABASE USER ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
• Save and close the file.
• Stop and Start vPostgres service.
• Now open CMD as Admin
• Go to C:\Program Files\VMware\vCenter Server\vPostgres\bin> and run psql -d VCDB -U postgres
• Once logged into DB, run the below command to update the password.
ALTER USER postgres PASSWORD 'new_password'; (You can use the same password as the vcpassword under vcbd.properties file : C:\ProgramData\VMware\vCenterServer\cfg\vmware-vpx)
• Once the password is set, revert the changes on pg_hba file and restart vPostgres service.
Now create a pgpass.conf file with below contents with the updated password for postgres user and save the file to C:\Windows\System32\config\systemprofile\AppData\Roaming\postgresql and C:\Users\XXXX\AppData\Roaming\postgresql\
localhost:5432:postgres:postgres:NEWPASSWORD
127.0.0.1:5432:postgres:postgres:NEWPASSWORD
localhost:5432:VCDB:postgres:NEWPASSWORD
127.0.0.1:5432:VCDB:postgres:NEWPASSWORD
