- Require sudo access for ‘sagacity’ user, to re-install the components of the Application.
(i) sudo visudo
(ii) sagacity All=(ALL) ALL
- Take a backup of whole Application including ApplicationDB and ComputeDB.
(i) /opt/infogix/sagacity-3.0/bin/backup
(ii) Take a backup of install.properties (/opt/infogix/sagacity-3.0/properties)
(iii) Take a backup of ssh-config directory (/opt/infogix/sagacity-3.0/ssh-config)
- Execute the uninstall command
/opt/infogix/sagacity-3.0/bin/uninstall
- Rename or Move ‘sagacity-3.0’ directory
/opt/infogix/sagacity-3.0
- Extract new binaries of DQ+
- Setting up the new install.properties file using help of backup one.
/opt/infogix/sagacity-3.3/properties/install.properties
- Copy the files under backup ssh-config into new ssh-config directory.
/opt/infogix/sagacity-3.3/ssh-config/
- Execute verifyEnvironment and verifyVerticaRequirements scripts.
(i) /opt/infogix/sagacity-3.3/bin/verifyEnvironment
(ii) /opt/infogix/sagacity-3.3/bin/verifyVerticaRequirements
- Execute install & initialize command.
(i) /opt/infogix/sagacity-3.3/bin/install
(ii) If above command finished without error, then execute /opt/infogix/sagacity-3.3/bin/initialize
- Restoring Databases.
ApplicationDB Restoration :
(i) /opt/infogix/sagacity-3.3/bin/stopApplication
(ii) /opt/infogix/sagacity-3.3/bin/restore applicationdb list
(iii) Under ApplicationDB server execute : docker exec -it sagacityApplicationDb dropdb -U postgres igxsagacity
(iv) From Maintenance Node execute : /opt/infogix/sagacity-3.3/bin/restore applicationdb {provide the name of DB from the list (ii)}
(vii) Once restoration finish, jump back to ApplicationDB server and execute :
docker exec -it sagacityApplicationDb psql -U postgres -d igxsagacity -tAc 'alter database igxsagacity SET search_path TO sagacity,"$user", public;'
(viii) /opt/infogix/sagacity-3.3/bin/startApplication
ComputeDB Restoration :
(ix) /opt/infogix/sagacity-3.3/bin/restore computedb list
(x) /opt/infogix/sagacity-3.3/bin/restore computedb {choose the restoration point from the list (i)}
- Restarting DQ+ Application
(i) /opt/infogix/sagacity-3.3/bin/stop
(ii) /opt/infogix/sagacity-3.3/bin/start
Comments
0 comments
Please sign in to leave a comment.