vRealize Operations upgrade from 8.1.1 to 8.6.3 pre-upgrade assessment check failure

Products

• VMware vRealize Operations 8.x
• VMware Aria Operations 8.x

Issue/Introduction

During the pre-upgrade assessment tool check, you may encounter the following error message.

 

Environment

8.1.1

8.2

Resolution

Steps to fix the pgpass permission issue:

 

1. Take the cluster offline and take snapshots per https://knowledge.broadcom.com/external/article?legacyId=2149269
   
   
2. SSH to the primary node as root, and run the following commands to correct the permissions on .pgpass
   

   # rm /storage/db/vcops/recovery.conf.bootstrap
   
   # chown postgres:users /var/vmware/vpostgres/current/.pgpass

3. SSH to the replica node as root, and run the following command to correct the permissions on .pgpass
   

   # chown postgres:users /var/vmware/vpostgres/current/.pgpass

4. From SSH to the primary node, manually start repl db service
   

   # /etc/init.d/vpostgres-repl start

5. From SSH to the replica node, manually start repl db service
   

   # /etc/init.d/vpostgres-repl start

6. Re-run the assessment tool.

 

Note: If the "recovery.conf.bootstrap" file is missing from any other nodes as well, proceed with the remaining steps to resolve the issue. Do not remove the file from replica node, except for the master node.

Additional Information

VMware Aria Operations Pre-Upgrade Readiness Assessment Tools: https://knowledge.broadcom.com/external/article/324352/vmware-aria-operations-preupgrade-readin.html