Prerequisite: The same prerequisites that are required to deploy the infrastructure are also needed when upgrading, see Setup requirements.
Warning: Upgrading infrastructure from earlier releases will
destroy the existing Postgres single-server infrastructure and database. Ensure you have
performed database backup step before running
setup.py.- Download the latest installer zip file.
- Extract the files in the location where you want to run the upgrade, and locate the
infra/azure/configfolder. - Copy the following files from your existing installation directory into the new
infra/azure/configfolder:terraform.tfstatedqplus.tfvarsdqplus.propertiespw.properties
- If you want to change any existing settings as part of the upgrade, such as instance sizes, or the max count of an instances for a component, edit the appropriate line in the
dqplus.tfvarsfile. - Stop the application service and ensure that there are no Data360 DQ+ initiated jobs running.
- Backup the existing Postgres database prior to upgrading the infrastructure. This is
critical as upgrading will destroy the existing single-server database. Connect to the
existing single-server Postgres database from a VM in the 'installation' subnet and perform
a full database dump using the following command. Replace
<deploymentid>with your actual deployment id:PGHOST=<deploymentid>-dqplus.postgres.database.azure.com PGUSER=igxcafe@<deploymentid>-dqplus PGPORT=5432 PGDATABASE=igxcafe PGSSLMODE=require pg_dump -Fd -j 2 igxcafe -h $PGHOST -p $PGPORT -U $PGUSER -N cron -f igxcafe_dump - Within your existing keyvault, grant the application corresponding to the installation virtual machine the Get Rotation Policy operation.
- From the
infra/azure/configdirectory run the following command:python3 ./setup.pyThe script checks for existing files and uses any existing values. You will only be asked to provide a value if it does not already exist.
- Once the infrastructure upgrade is complete, restore your backup of Postgres database. Use
the following template, replacing
<deploymentid>with your actual deployment id:export PGSSLMODE=require pg_restore -Fd -j 2 -d igxcafe igxcafe_dump -h <deploymentid>-dqplus.postgres.database.azure.com -p 5432 -U igxcafe@<deploymentid>-dqplus 2> errors.log. - Review the
errors.logfile. You can ignore the error 'ALTER SCHEMA public OWNER TO azure_superuser'. - You can install the application using the
dqplus.propertiesandpw.propertiesfiles, see Installing the application.