As needed, the  can be installed as PostgreSQL DBs on Amazon RDS. Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. 



NOTE: You can use the suggested defaults below for sizing your RDS instance. If you have questions or concerns about sizing recommendations, please contact .

Initialize RDS instance


  1. In your RDS dashboard, click Launch a DB instance. 

    NOTE: The RDS instance must be launched in the same Amazon region as the .

  2. For Select Engine: Select PostgresSQL.
  3. For Production?:  Choose Yes if you are deploying the database for a production instance of the .  Otherwise, select No
  4. DB Engine: postgres
  5. For the DB details, see below:

    NOTE: Except as noted below, properties should be specified according to your enterprise requirements.

    1. Instance Specifications:

      1. License Model: postresql-license
      2. DB Engine Version: For more information on the supported versions of PostgreSQL, see System Requirements.
      3. Allocated Storage: at least 10 GB

  6. For Advanced Settings, please apply the following settings:

    1. Network and Security:

      1. VPC security group must allow for access from the 

    2. Database Options:

      1. Database Name: trifacta

      2. Database Port: 5432

        1. The port number can be changed as needed. See System Ports.

  7. Populate other properties according to your enterprise requirements.

  8. To complete the set up click Launch DB Instance.

  9. Create a master username and password for the DB instance.

    NOTE: In the configuration instructions listed below, this master username is referenced as: trifacta_rds.

  10. When the RDS DB instance is up and running, please collect the following information, which is used later:
    1. Public DNS
    2. Port Number
    3. Admin username
    4. Admin password

Configure the  for RDS

Please complete the following steps to integrate the  with the DB instance you just created.


  1. In the RDS console, you must find the Public DNS endpoint for the RDS instance you created: 

    1. Under Instances, expand the name of the instance you created.

    2. The DNS endpoint should be listed under the name in the Endpoint section.

  2. Set the host for each database to the Public DNS endpoint for the RDS instance:

    Time-based Trigger
    Configuration Service
    Artifact Storage Service


  3. To set custom database names, usernames, and passwords:

    1. Edit 

    2. For each database below, you can review the database name, username, and password. 

      Time-Based Trigger
      Configuration Service
      Artifact Storage Service

    3. Make changes in the file as needed and save.

Initialize the databases

Use the following steps to initialize the databases required by the platform.



  1. Switch to the Postgres user. Launch psql.

    sudo su - postgres

    NOTE: Unless the port number for postgres has been modified, it should be listening at the default value: 5432.

  2. Launch psql using the following command, applying the admin password when prompted:

    psql --host=${RDS_HOST_NAME} --port=${RDS_PORT} --username=${RDS_ADMIN_USERNAME} --password=${RDS_ADMIN_PASSWORD}


    hostPublic DNS value for the RDS instance
    portPort number value for the RDS instance
    usernameAdmin username for the RDS instance
    passwordPassword for admin username

  3. Execute the following commands using the postgres user.

    NOTE: The values in platform configuration must match the values that you use below. Below are the default values.


    1. For :

      CREATE ROLE trifacta LOGIN ENCRYPTED PASSWORD '<pwd_trifacta>';
      GRANT trifacta TO trifacta_rds;
      CREATE DATABASE trifacta WITH OWNER trifacta;


    2. For Jobs database:

      CREATE ROLE trifactaactiviti WITH LOGIN ENCRYPTED PASSWORD '<pwd_trifactaactiviti>';
      GRANT trifactaactiviti TO trifacta_rds;
      CREATE DATABASE "trifacta-activiti" WITH OWNER trifactaactiviti;


    3. For Scheduling database:

      CREATE ROLE trifactaschedulingservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactaschedulingservice>';
      GRANT trifactaschedulingservice TO trifacta_rds;
      CREATE DATABASE trifactaschedulingservice WITH OWNER trifactaschedulingservice;

      For more information on scheduling, see Configure Automator.

    4. For Time-based Trigger database:

      CREATE ROLE trifactatimebasedtriggerservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactatimebasedtriggerservice>';
      GRANT trifactatimebasedtriggerservice TO trifacta_rds;
      CREATE DATABASE trifactatimebasedtriggerservice WITH OWNER trifactatimebasedtriggerservice;

      For more information on scheduling, see Configure Automator.

    5. For Configuration Service database:

      CREATE ROLE trifactaconfigurationservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactaconfigurationservice>';
      GRANT trifactaconfigurationservice TO trifacta_rds;
      CREATE DATABASE trifactaconfigurationservice WITH OWNER trifactaconfigurationservice;

    6. For Artifact Storage Service database:

      CREATE ROLE trifactaartifactstorageservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactaartifactstorageservice>';
      GRANT trifactaartifactstorageservice TO trifacta_rds;
      CREATE DATABASE trifactaartifactstorageservice WITH OWNER trifactaartifactstorageservice;

    7. Exit:


Configure non-default connections

If you have used non-default values for the username, password, host, or port value for either database, you must update platform configuration. 


NOTE: Do not modify the other properties in these sections unless necessary.

"webapp.database.username": "trifacta",
"webapp.database.logging": false,
"": "trifacta",
"": "localhost",
"webapp.database.password": "<pwd_trifactaDB>",
"webapp.database.type": "postgressql",
"webapp.database.port": 5432,
"webapp.database.pool.maxIdleTimeInMillis": 30000,
"webapp.database.pool.maxConnections": 10,

The following parameters apply to the  only:


Set this value to true to enable logging on the .

pool.maxIdleTimeInMillisSpecifies the maximum permitted idle time for a database connection before it is automatically closed.

Defines the maximum permitted database connections for the .

Additional parameters are described below.

Jobs database

Modify the batch-job-runner.database settings:

"batch-job-runner.database.username": "trifactaactiviti", 
"": "trifacta-activiti", 
"batch-job-runner.database.driver": "org.postgresql.Driver", 
"": "localhost", 
"batch-job-runner.database.password": "<pwd_trifactaactivitiDB>", 
"batch-job-runner.database.port": 5432,  

Scheduling service database 

"scheduling-service.database.type": "POSTGRESQL",
"": "localhost",
"scheduling-service.database.port": "5432",
"": "trifactaschedulingservice",
"scheduling-service.database.username": "trifactaschedulingservice",
"scheduling-service.database.password": "<pwd_schedulingserviceDB>" 

Time-based trigger service database 

"time-based-trigger-service.database.type": "POSTGRESQL",
"": "localhost",
"time-based-trigger-service.database.port": "5432",
"": "trifactatimebasedtriggerservice",
"time-based-trigger-service.database.username": "trifactatimebasedtriggerservice",
"time-based-trigger-service.database.password": "<pwd_triggerserviceDB>"

Configuration service database 

"configuration-service.database.type": "POSTGRESQL",
"": "localhost",
"configuration-service.database.port": "5432",
"": "trifactaconfigurationservice",
"configuration-service.database.username": "trifactaconfigurationservice",
"configuration-service.database.password": "<pwd_configurationserviceDB>"

Artifact storage service database 

"artifact-storage-service.database.type": "POSTGRESQL",
"": "localhost",
"artifact-storage-service.database.port": "5432",
"": "trifactaartifactstorageservice",
"artifact-storage-service.database.username": "trifactaartifactstorageservice",
"artifact-storage-service.database.password": "<pwd_trifactaartifactstorageserviceDB>"


Database Parameter Reference

The following generalized parameters apply to one or more of the databases. 


Host of the database. Default value is localhost, meaning the database is hosted on the .

portPort number for the database. Default value is 5432 for all databases.
nameName of the database. This value should match what was used during installation.
user or usernameThe username to use to connect to the database.
passwordPassword to use to connect to the database.
typeThis value should be set to POSTGRESQL. Do not modify.
driverName of the database. Do not modify.

Save your changes and restart the platform.


  1. To review database logs in RDS, locate the Instance details page in the RDS console.
  2. Click Recent Events and Logs.
  3. If your account has the appropriate permissions, all  logs are available here.