Upgrade DQ+ Enterprise version

Below are the general DQ+ Enterprise version upgrade steps. Please refer to DQ+ Enterprise installation guide for additional steps for specific steps.

Sometimes steps may vary, so it's highly recommended to check version specific installation guide.

1. Take a backup by running the following command:

   ./backup

2. Uninstall the current version, and remove data.

   ./uninstall

3. Extract new version ".sh" file, by default it extracts to "/opt/infogix/dq-plus{version}
   
   
4. Open new install.properties file in vi-editor under /opt/infogix/dq-plus{version}/properties/"  and set it according to your old install.properties file. 
   
   
5. Install the new version:

    ./install

6. Initialize:

   ./initialize

7. Restore the backup, as follows:
           a.) Clean-up the application database:
                   (i) Stop the application before erasing its database by running

                        ./stopApplication in /bin. 

                   (ii) Step into the ApplicationDb Docker Container:

                        docker exec -it sagacityApplicationDb bash 

                  (iii) Obtain a connection to the PostgreSQL database, within the ApplicationDb Docker                             Container:

                        psql -U postgres -d igxsagacity 

                   (iv) 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. 
   
            b.) Restore the application database: 
                     (i) Run the following command to list all available application database backups:

                          ./restore applicationdb list

                     (ii) 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

                       (iii) Start Application after successful restore

                             ./startApplication

   
                c.) Restore the compute database:
                         (i) Run the following command to list all available compute database backups:

                              ./restore computedb list

                         (ii) Run the following command, pointing to the specific backup that you want to                                     restore to:

                              ./restore computedb 20170622220804

   
   
   
8. Restart the application by running the following commands:

   ./stop

   ./start

(Note: The brief article on How to backup and restore Application DB and Compute Db also available here).