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 127.0.0.1/32 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
0 commenti:
Post a Comment