Page tree

Release 8.2




After you have completed the upgrade of the software on the Trifacta node, you may need to migrate some pre-upgrade configuration values to the new environment. 

These migrations steps should be performed whenever you upgrade between any two versions, even if you have not modified any configuration values. If there are no migrations to be performed, the process does not harm.

Do not restart the software until instructed to do so.

Create New Databases

NOTE: Please stop the databases before you create the new ones.

After upgrade, you may need to create new databases depending on your pre- and post-upgrade releases.

Tip: This step is harmless if there are no new databases to create for this upgrade.

For more information, see Install Databases in the Databases Guide.

Modify pg_hba.conf (PostgreSQL only)

Any new databases must be referenced in pg_hba.conf.


  1. Locate the sample Postgres configuration file:

  2. If you are upgrading and have customizations in your existing version, you must apply the edits in the above to the following file. Otherwise, overwrite the following file with the above one based on your operating system:
    1. CentOS/RHEL dir: /var/lib/pgsql/9.6/data/pg_hba.conf
    2. Ubuntu dir: /etc/postgresql/9.6/main/pg_hba.conf

  3. From the SAMPLE file, copy the appropriate declarations and paste them into the production pg_hba.conf file above any other declarations.

    1. For more information on the declarations, see Configure the Databases in the Databases Guide.

  4. Save the file.

  5. Restart PostgreSQL.

Create DBs

Before you run the following script, please create a backup of

in its current state. This backup is used to restore values after you have completed the script execution. It is important that you take the backup at this time.

  1. Run the following script, which creates any new databases and users and roles for accessing them.

    1. PostgreSQL:

      sudo /opt/trifacta/bin/setup-utils/db/
    2. MySQL:

      /opt/trifacta/bin/setup-utils/db/ -u <MySql_admin_username> -w <MySql_admin_password>
    3. See Create Databases and Users in the Databases Guide.
  2. Restore
    from the backup you created of that file.
  3. Restart the databases.


Data Service property updates for Release 7.1

NOTE: This step applies if you are upgrading from a pre-Release 7.1 to Release 7.1 or later.

After the platform has been upgraded to Release 7.1, some of the migrated properties are submitted from the file used to configure the data service. These properties are no longer directly editable by users.

If you have modified property values in, you must migrate your old values into the new file to retain your customized property values. The migration process gathers these values from the file and inserts them as the new values in the Configuration Service database. If you fail to complete these steps and need to retain our change property values, please contact Trifacta Customer Success Services.


  1. Login to the Trifacta node. Navigate to the following directory:

  2. Perform a diff between the following two files:

    1. (pre-upgrade file)

    2. (file used during migration)

  3. Merge property values:

    NOTE: Property values in must be migrated into for inclusion in the Configuration Service database or (if not migrated) preservation in the upgraded deployment.

  4. Save the file. You should archive the rpmsave version to a location outside of the }Trifacta deployment.
  5. Complete the rest of the steps to migrate your configuration in the sections below.
  6. When the platform is restarted at the end of the migration process, the property values in your pre-upgrade are inserted as the new values for the properties maintained in the Configuration Service database.

Migrate Values to Configuration Service

During the upgrade process, some configuration properties are automatically migrated to the Configuration Service. In most cases, these properties are automatically enabled and are hidden from view. For more information, see Changes to Configuration in the Release Notes.

Merge Customized Configuration Files

After upgrading the software, you should scan the install directory tree for .rpmnew files. These files are the default versions of configuration files from the new software distribution that were written in parallel to a modified configuration file from the previous version.


  1. Review the following directories and files for .rpmnew versions:

    NOTE: Do not perform manual migrations of

    . Migrations of this file are automatically performed as part of the upgrade process.

  2. Configuration settings from the old files must be explicitly merged into the new files (*.rpmnew). 
  3. Remove old files from Trifacta install directory:
    1. Create a directory outside of the Trifacta install directory.
    2. Move all of the config files from the previous version into this directory.

      NOTE: Do not leave the old config files in the install directory. There should not be multiple configuration files of the same kind.

    3. Rename these old config files outside of the directory to include a .backup extension. You could also put the version number of the config file. 
  4. The .rpmnew extension must be removed from the new files.
  5. Your previous configuration should be carried forward into the new version.

Migrate properties for remote databases

If you have installed the Trifacta databases on a remote server, you must repopulate the values in

for the remote host, port, and other connection properties for your remote databases. Properties must also be populated for any new databases that were created as part of this upgrade process.

For more information, see Database Parameter Reference.

Next Steps

While the platform can now start, you should avoid doing so until have you completed all required steps in this guide.

NOTE: Please be sure to review any post-upgrade instructions and perform any post-upgrade cleanup in the following sections.

This page has no comments.