Data360 DQ+ upgrade Instructions

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

Articles in this section

Comments

Articles in this section

Related articles