Error: "Unable to validate version of postgres" during the upgrade of Collibra

On Linux, you have to install PostgreSQL 14.9 on all nodes that have the Repository, Jobserver and Collibra Console before you upgrade to Collibra Data Governance Center 5.9.

During the upgrade it is possible that you get the following error message:

Unable to validate version of postgres.

Cause

A potential cause is that there was a previous failed installation that left the system in a state with a missing version file.

Resolution

1. Go to /opt/collibra_data/spark-jobserver/pgsql-data.
2. In this situation, the file PG_VERSION is not available in this folder.
3. If the file is missing, the execute the following commands:

   echo 14 >> PG_VERSION
   chown collibra:collibra PG_VERSION

4. Restart the upgrade procedure.