Prepare for disaster recovery - Data360_DQ+ - 11.2

Schedule backups

1. Manually add the backupApplicationDb and backupComputeDb tasks to the crontab file. Include the frequency at which you want to perform backups in the following format:

   <Minute> < Hour> <DayOfMonth> < Month> <DayOfWeek> < Command>

   For example, to run a full backup of the ApplicationDB and ComputeDB components every day at midnight, add the following:

   0 0 * * * /opt/infogix/dqplus/bin/backupApplicationDb

   0 0 * * * /opt/infogix/dqplus/bin/backupComputeDb

Restore the system

1. Backup the application database by executing the backupApplicationDb script from the <dqplus home>/bin directory:

   ./backupApplicationDb

2. Clean-up the application database:
   1. Stop the application before erasing its database:

      <dqplus home>/bin /stopApplication

   2. Step into the ApplicationDb Docker Container:

      docker exec -it dqplusApplicationDb bash

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

      psql -U postgres -d igxsagacity

   4. 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.
   5. Exit the PostgreSQL shell and the Docker container:
      • \q ends the current psql session
      • exit exits the current Docker session and returns you to the terminal
3. Restore the application database:
   1. To list all available application database backups, run the following command:

      ./restore applicationdb list

   2. To restore to a backup, run the following command, pointing to the specific backup that you want to restore to:

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

4. Restart the application after backup recovery:

   ./stop

   ./start

5. Backup the Compute database:
   1. Run the backupComputeDb script from the <dqplus home>/bin directory:

      ./backupComputeDb

   2. To list all available compute database backups, run this command:

      ./restore computedb list

   3. Copy the sagacity_default_backup.ini file from the new backup location to the backup/configuration directory, for example, copy from:

      <backup location>/computeDb/full/20190613175428/configrations/sagacity_default_backup.ini

      to

      <backup location>/configrations/sagacity_default_backup.ini

   4. To restore to a backup, run the following command, pointing to the specific backup that you want to restore to:

      ./restore computedb 20170622220804

6. Restart the application after backup recovery:

   ./stop

   ./start