Symptoms:
/storage/vcops/log/sqldbupgrade.log
displays the following error: FATAL: could not load server certificate file "server.crt": No such file or directory
/storage/log/vcops/log/analytic.log
displays the following error FATAL: role "vcops" does not exist
VMware Aria Operations 8.x
VMware vRealize Operations Manager 7.0.x
VMware vRealize Operations Manager 6.7.x
VMware vRealize Operations Manager 6.6.x
The issue can be caused by corruption on the disk or SEsparse.
The issue may occur during a PostgreSQL schema upgrade from version 11 to version 14.
To resolve this issue, run a re-index on the alarms table in the postgres database.
With the re-index successful, take new snapshots of the vRealize Operations Manager nodes and attempt the upgrade process again. It should now complete successfully.
Steps to Modify Configuration and Complete PostgreSQL Upgrade
1. Revert to Previous Snapshot
Before making any changes, revert the system to the previous snapshot.
2. Modify Configuration
ssl=off
in the PostgreSQL configuration file./storage/db/vcops/vpostgres/data/postgresql.conf
3. Retry the Upgrade
4. After applying the above change, retry the PostgreSQL upgrade.
5. Confirm Upgrade Success
6. Verify that the upgrade has been completed successfully.
7. Re-enable SSL
ssl=on
in /storage/db/vcops/vpostgres/data/postgresql.conf
on all master and data nodes.By following these steps, the PostgreSQL upgrade should complete successfully with SSL re-enabled at the end.