...

1. Login to the 

   D s node

    as root user.

2. Stop the 

   D s item
   service service

   :

   Code Block
   service trifacta stop

   
   

3. Clear each current database and restore the backup of the version from the preceding release. In some cases, the database may not exist in the previous version.

   1. PostgreSQL:

      1. Login as a user that can run admin commands for PostgreSQL. This user may vary between deployments.

      2. D s item
         item database

         :

         Code Block
         psql -c "DROP DATABASE trifacta;" psql -c "CREATE DATABASE trifacta WITH OWNER trifacta;" psql --dbname=trifacta < trifactatrif_triDB_backupbkp_<date>.sql

         
         

      3. (Release 3.2 and later) Jobs database:

         Info
         NOTE: Please note the escaped quotes in the CREATE DATABASE command for this database.

         
         

         Code Block
         psql -c "DROP DATABASE \"trifacta-activiti\";" psql -c "CREATE DATABASE \"trifacta-activiti\" WITH OWNER trifactaactivit;" psql --dbname="trifacta-activiti" < trif_actDB_backupbkp_<date>.sql

         
         

      4. (Release 4.1 and later) Scheduling database:

         Code Block
         psql -c "DROP DATABASE trifactaschedulingservice;" psql -c "CREATE DATABASE trifactaschedulingservice WITH OWNER trifactascheduling;" psql --dbname=trifactaschedulingservice < trif_schedDBschDB_backupbkup_<date>.sql

         
         

      5. (Release 4.1 and later) Time-based Trigger Service database:

         Code Block
         psql -c "DROP DATABASE trifactatimebasedtriggerservice;" psql -c "CREATE DATABASE trifactatimebasedtriggerservice WITH OWNER trifactatimebasedtriggerservice;" psql --dbname=trifactatimebasedtriggerservice < tritrif_tbtsDB_backupbkup_<date>.sql

         
         

      6. (Release 6.0 and later) Configuration Service database:

         Code Block
         psql -c "DROP DATABASE trifactaconfigurationservice;" psql -c "CREATE DATABASE trifactaconfigurationservice WITH OWNER trifactaconfigurationservice;" psql --dbname=trifactaconfigurationservice < tritrif_confservDB_backupbkup_<date>.sql

         
         

      7. (Release 6.0 and later) Artifact Storage Service database:
         
         

         Conditional Content
         Products: (IBM-ADP) Products: (IBM-ADP) sv-attr:7F00000101503A27A167617707167EC7 AC120003016A94C461D6DA4049A8A356
         Info NOTE: This database is unused in this product. It may be used in the future for managing feature-specific data.

         
         

         Code Block
         psql -c "DROP DATABASE trifactaartifactstorageservice;" psql -c "CREATE DATABASE trifactaartifactstorageservice WITH OWNER trifactaartifactstorageservice;" psql --dbname=trifactaartifactstorageservice < tritrif_artifactstorageservDB_backupbkup_<date>.sql

         
         

      8. (Release 6.4 and later) Job Metadata Service database:

         Code Block
         psql -c "DROP DATABASE trifactajobmetadataservice;" psql -c "CREATE DATABASE trifactajobmetadataservice WITH OWNER trifactajobmetadataservice;" psql --dbname=trifactajobmetadataservice < tritrif_jobmetadataservDB_backupbkup_<date>.sql

         
         

   2. MySQL: For details, see https://dev.mysql.com/doc/refman/5.7/en/reloading-sql-format-dumps.html. 
      

      1. Login:

         Code Block
         su - mysql

         
         

      2. D s item
         item database

         :

         Code Block
         mysql trifacta < trifactatrif_triDB_backupbkp_<date>.sql

         
         

      3. Jobs database:

         Code Block
         mysql trifacta-activiti < trif_actDB_backupbkp_<date>.sql

         
         

      4. (Release 4.1 and later) Scheduling database:

         Code Block
         mysql trifactaschedulingservice < trif_schedDBschDB_backupbkup_<date>.sql

         
         

      5. (Release 4.1 and later) Time-based Trigger Service database:

         Code Block
         mysql trifactatimebasedtriggerservice < tritrif_tbtsDB_backupbkup_<date>.sql

         
         

      6. (Release 6.0 and later) Configuration Service database:

         Code Block
         mysql trifactaconfigurationservice < tritrif_confservDB_backupbkup_<date>.sql

         
         

      7. (Release 6.0 and later) Artifact Storage Service database:

         Conditional Content
         Products: (IBM-ADP) Products: (IBM-ADP) sv-attr:7F00000101503A27A167617707167EC7 AC120003016A94C461D6DA4049A8A356
         Info NOTE: This database is unused in this product. It may be used in the future for managing feature-specific data.

         
         

         Code Block
         mysql trifactaartifactstorageservice < tritrif_artifactstorageservDB_backupbkup_<date>.sql

         
         

      8. (Release 6.4 and later) Job Metadata Service database:

         Code Block
         mysql trifactajobmetadataservice < tritrif_jobmetadataservDB_backupbkup_<date>.sql

         
         

4. Uninstall the current version of the 

   D s item
   item software

   :
   

   D excerpt include
   page Uninstall nopanel true

5. Perform a clean install of the 

   D s item
   item software

    provided in your distribution. See Install.

6. Restore your configuration files. The following commands assume that they were backed up to the /tmp directory on the node:

   Code Block
   cp /tmp/trifacta-conf.json /opt/trifacta/conf/trifacta-conf.json cp /tmp/env.sh /opt/trifacta/conf/env.sh cp /tmp/trifacta.service /etc/init.d/trifacta

   
   

7. Apply any patches or maintenance updates that may have been provided to you. See Maintenance Release Updater.
8. Restart the platform. See Start and Stop the Platform.
9. Login and verify operations. See Verify Operations.