Perform an upgrade - Data360_DQ+ - 11.2

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

./stop