...
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 - For Select Engine: Select PostgresSQL.
- For Production?: Choose Yes if you are deploying the database for a production instance of the
. Otherwise, select No.D s platform - DB Engine:
postgres
For the DB details, see below:
Info NOTE: Except as noted below, properties should be specified according to your enterprise requirements.
Instance Specifications:
- License Model:
postresql-license
- DB Engine Version: For more information on the supported versions of PostgreSQL, see System Requirements.
Allocated Storage: at least
10 GB
- License Model:
For Advanced Settings, please apply the following settings:
Network and Security:
VPC security group must allow for access from the
.D s platform
Database Options:
Database Name:
trifacta
Database Port:
5432
The port number can be changed as needed. See System Ports.
Populate other properties according to your enterprise requirements.
To complete the set up click Launch DB Instance.
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
.- When the RDS DB instance is up and running, please collect the following information, which is used later:
- Public DNS
- Port Number
- Admin username
- Admin password
...
In the RDS console, you must find the Public DNS endpoint for the RDS instance you created:
Under Instances, expand the name of the instance you created.
The DNS endpoint should be listed under the name in the Endpoint section.
Set the
host
for each database to the Public DNS endpoint for the RDS instance:Database Parameter Main database webapp.database.host
Jobs database batch-job-runner.database.host
Scheduling database scheduling-service.database.host
Time-based Trigger database time-based-trigger-service.database.host
Configuration Service database configuration-service.database.host
Artifact Storage Service database
artifact-storage-service.database.host
Job Metadata Service database job-metadata-service.database.host
For more information, see Database Parameter Reference.
To set custom database names, usernames, and passwords:
Edit
.D s triconf path true For each database, you can review the database
name
,username
, andpassword
.Database Parameter area Main database webapp.database.*
Jobs database batch-job-runner.database.*
Scheduling database scheduling-service.database.*
Time-Based Trigger database time-based-trigger-service.database.*
Configuration Service database configuration-service.database.*
Artifact Storage Service database
artifact-storage-service.database.*
Job Metadata Service database job-metadata-service.database.*
- Make changes in the file as needed and save.
...
Create the databases
Info |
---|
NOTE: For the host, port, username, and password values in the following configuration, use the public DNS value for the RDS instance. |
...
From the
D s item | ||
---|---|---|
|
Code Block |
---|
su - postgres
psql -H <endpoint of RDS Instance> -U trifacta_rds postgres |
Info |
---|
NOTE: |
Please do the following for each database, which initializes the DB and assigns the trifacta
role to the trifacta_rds
master username:
: D s item item database
Code Block |
---|
CREATE ROLE trifacta LOGIN ENCRYPTED PASSWORD 'trifacta';
GRANT trifacta TO trifacta_rds;
CREATE DATABASE "trifacta" WITH OWNER trifacta; |
Jobs database:
Code Block |
---|
CREATE ROLE trifactaactiviti LOGIN ENCRYPTED PASSWORD 'trifactaactiviti';
GRANT trifactaactiviti TO trifacta_rds;
CREATE DATABASE "trifacta-activiti" WITH OWNER trifactaactiviti; |
Time-based trigger service database:
Code Block |
---|
CREATE ROLE trifactatimebasedtriggerservice LOGIN ENCRYPTED PASSWORD 'trifactatimebasedtriggerservice';
GRANT trifactatimebasedtriggerservice TO trifacta_rds;
CREATE DATABASE "trifactatimebasedtriggerservice" WITH OWNER trifactatimebasedtriggerservice; |
Scheduling service database:
Code Block |
---|
CREATE ROLE trifactaschedulingservice LOGIN ENCRYPTED PASSWORD 'trifactaschedulingservice';
GRANT trifactaschedulingservice TO trifacta_rds;
CREATE DATABASE "trifactaschedulingservice" WITH OWNER trifactaschedulingservice; |
Configuration Service database:
Code Block |
---|
CREATE ROLE trifactaconfigurationservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactaconfigurationservice>';
GRANT trifactaconfigurationservice TO trifacta_rds;
CREATE DATABASE trifactaconfigurationservice WITH OWNER trifactaconfigurationservice; |
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; |
Job Metadata Service database:
Code Block |
---|
CREATE ROLE trifactajobmetadataservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactajobmetadataservice>';
GRANT trifactajobmetadataservice TO trifacta_rds;
CREATE DATABASE trifactajobmetadataservice WITH OWNER trifactajobmetadataservice; |
Configure non-default connections
...