Check the repository before an upgrade

If you upgrade from a version 5.7.6 or older to 5.7.7 or newer, we highly recommend to check the health of your repository. To do the health check, you can download a script. This script detects any possible issues that may block the upgrade of your environment.

The script does not change any data in the Repository and has minimal impact on the performance. There is no need to stop the environment.

Tip This procedure is not necessary if your current version is 5.7.7 or newer.

Steps

1. Download the script upgrade_checkup_script.sql from the Collibra Downloads page.
2. Sign in to the server that hosts the Repository service.
3. Save the script in a temporary directory, for example /tmp.
4. From the temporary directory, run the following command:

   • Linux:

     #set environment variable
     export PGPASSFILE={path_to_collibra_data_dir}/repo/data/.pgpass;
     
     #execute script
     {path_to_repo_installation_dir}/pgsql/bin/psql -p 4403 -U collibra -d dgc -q -f upgrade_checkup_script.sql >> checkup_result.txt

     Example 

     export PGPASSFILE=/collibra_data/repo/data/.pgpass; collibra/pgsql/bin/psql -p 4403 -U collibra -d dgc -q -f upgrade_checkup_script.sql >> checkup_result.txt

   • Windows Powershell:

     #set environment variable
     env:PGPASSFILE="{path_to_collibra_data_dir}/repo/data/pgpass.conf;
     
     #execute script
     {path_to_repo_installation_dir}/pgsql/bin/psql -p 4403 -U collibra -d dgc -q -f upgrade_checkup_script.sql >> checkup_result.txt

   • Windows command prompt:

     #set environment variable
     SET PGPASSFILE={path_to_collibra_data_dir}/repo/data/pgpass.conf; 
     
     #execute script
     {path_to_repo_installation_dir}/pgsql/bin/psql -p 4403 -U collibra -d dgc -q -f upgrade_checkup_script.sql >> checkup_result.txt

What's next?

The file checkup_result.txt is created in your temporary directory. You can open the file in a text editor.

At the end of the file, you can find the status of the checkup.