Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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
        itemdatabase
        :

        Code Block
        psql -c "DROP DATABASE trifacta;"
        psql -c "CREATE DATABASE trifacta WITH OWNER trifacta;"
        psql --dbname=trifacta < trifacta_backup_<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_backup_<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_schedDB_backup_<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 < tri_tbtsDB_backup_<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 < tri_confservDB_backup_<date>.sql


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

        Code Block
        psql -c "DROP DATABASE trifactaartifactstorageservice;"
        psql -c "CREATE DATABASE trifactaartifactstorageservice WITH OWNER trifactatrifactaartifactstorageservicetrifactaartifactstorageservice;"
        psql --dbname=trifactaartifactstorageservice < tri_artifactstorageservDB_backup_<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
        itemdatabase
        :

        Code Block
        mysql trifacta < trifacta_backup_<date>.sql


      3. Jobs database:

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


      4. (Release 4.1 and later) Scheduling database:

        Code Block
        mysql trifactaschedulingservice < trif_schedDB_backup_<date>.sql


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

        Code Block
        mysql trifactatimebasedtriggerservice < tri_tbtsDB_backup_<date>.sql


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

        Code Block
        mysql trifactaconfigurationservice < tri_confservDB_backup_<date>.sql


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

        Code Block
        mysql trifactaartifactstorageservice < tri_artifactstorageservDB_backup_<date>.sql


  4. Uninstall the current version of the 
    D s item
    itemsoftware
    :
    D excerpt include
    pageUninstall
    nopaneltrue
  5. Perform a clean install of the 
    D s item
    itemsoftware
     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.