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.
- Take a backup by running the following command:
./backup
- Uninstall the current version, and remove data.
./uninstall
- Extract new version ".sh" file, by default it extracts to "/opt/infogix/dq-plus{version}
- 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.
- Install the new version:
./install
- Initialize:
./initialize
- 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
- 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).
Comments
0 comments
Please sign in to leave a comment.