"Pgpass.conf file cannot be found" while upgrading vCenter server from 6.0 to 6.5 pre-installation fails.

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• Upgrading vCenter server from 6.0 to 6.5 pre-installation fails with "Pgpass.conf file cannot be found"

Environment

VMware vCenter Server 6.5.x
VMware vCenter Server 6.0.x

Cause

pgpass.conf file is missing in below location C:\Windows\System32\config\systemprofile\AppData\Roaming\postgresql\pgpass.conf

 

Resolution

To  resolve this issue we need to create the missing pgpass.conf file using below steps:

1. Go to the below location and add the contents.
   • Location: "C:\Windows\System32\config\systemprofile\AppData\Roaming\postgresql\pgpass.conf"
   • Create a new text file with name pgpass.conf
   • Add the below content and save pgpass.conf file

localhost:5432:postgres:postgres:new_password
127.0.0.1:5432:postgres:postgres:new_password
localhost:5432:VCDB:postgres:new_password
127.0.0.1:5432:VCDB:postgres:new_password

2. Login to the VCDB and update the password using with the new password created in the previous step,
   • /opt/vmware/vpostgres/9.0/bin/psql -d VCDB -U postgres
   • ALTER USER postgres PASSWORD 'new_password';

Note: You need postgres account password to create this file, if not aware of the password you can refer vcdb.properties if that does not work, you can be reset the password using KB article.