Performing an upgrade - Data360_DQ+ - 11.X

Data360 DQ+ Enterprise Installation

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 DQ+
Version
11.X
Language
English
Product name
Data360 DQ+
Title
Data360 DQ+ Enterprise Installation
Copyright
2024
First publish date
2016
ft:lastEdition
2024-06-06
ft:lastPublication
2024-06-06T12:37:34.761477
  1. Take a backup by running the following command: ./backup
  2. Uninstall the current version, and remove data.
  3. Install RedHat Enterprise Linux 8.9.
  4. Install the new version.
  5. Restore the backup:
    1. Clean-up the application database:

      • Stop the application before erasing its database by running ./stopApplication in <dqplus home>/bin.
      • Step into the ApplicationDb Docker Container:

        docker exec -it dqplusApplicationDb bash

      • Obtain a connection to the PostgreSQL database, within the ApplicationDb Docker Container:

        psql -U postgres -d igxsagacity

      • Drop the application schema:

        DROP SCHEMA sagacity CASCADE;

        Note: The application database backup is a full backup of the schema, therefore the schema will be created as a part of the restore process.
      • Exit the PostgreSQL shell and the Docker container:
        • \q ends the current PostgreSQL session.
        • exit exits the current Docker session and takes you back to the terminal.
    2. Restore the application database:
      • Run this command to list all available application database backups:

        ./restore applicationdb list

      • Run this command, pointing to the specific backup that you want to restore to:

        ./restore applicationdb 2017-08-09-11-21/igxsagacity_backup.sql.gz

    3. Restore the compute database:
      • Run this command to list all available compute database backups:

        ./restore computedb list

      • Run this command, pointing to the specific backup that you want to restore to:

        ./restore computedb 20170622220804

  6. Restart the application by running these commands:

    ./stop

    ./start