...

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

   Info
   NOTE: The RDS instance must be launched in the same Amazon region as the D s node .

   
   

2. For Select Engine: Select PostgresSQL.
3. For Production?:  Choose Yes if you are deploying the database for a production instance of the 

   D s platform

   .  Otherwise, select No. 
4. DB Engine: postgres

5. For the DB details, see below:

   Info
   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 

         D s platform

         . 

   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.

   Info
   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

...

1. Switch to the Postgres user. Launch psql.

   Code Block
   sudo su - postgres

   
   

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

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

   where:
   
   

   Parameter	Description
   host	Public DNS value for the RDS instance
   port	Port number value for the RDS instance
   username	Admin username for the RDS instance
   password	Password for admin username

   
   

3. Execute the following commands using the postgres user.
   

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

    

   1. For 

      D s item
      item database

      :
      

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

       

   2. For Jobs database:
      

      Code Block
      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:
      

      Code Block
      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:
      

      Code Block
      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:
      

      Code Block
      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:
      
      

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

      
      

   7. Exit:

      Code Block
      \q exit

      
      

...