You should change the passwords for the Trifacta® databases immediately after installing the software.
Please complete the following steps to change the passwords for the Trifacta platform users of the Trifacta databases.
Change via SQL:
If you have not done so already, switch to the Postgres user and launch psql:
sudo su - postgres psql
For each database, change the default password, where
trifacta
andtrifacta-activiti
correspond to the default roles of the two databases, respectively. Please modify the command if you are using different roles and insert a more secure password for<new_pwd>
:ALTER ROLE trifacta WITH PASSWORD '<new_pwd>'; ALTER ROLE trifacta-activiti WITH PASSWORD '<new_pwd>';
Exit psql:
\q exit
Change via Trifacta configuration:
Below are the username and password properties for each database. You can apply this change through the Admin Settings Page (recommended) or
trifacta-conf.json
. For more information, see Platform Configuration Methods. Please review and update as needed:Trifacta database:
"webapp.db.username" = "<user>", "webapp.db.password" = "<pwd>",
Jobs database:
"batch-job-runner.db.username" = "<user>", "batch-job-runner.db.password" = "<pwd>",
Scheduling database:
"scheduling-service.database.user" = "<user>", "scheduling-service.password.password" = "<pwd>",
Time-based trigger database:
"time-based-trigger-service.database.user" = "<user>", "time-based-trigger-service.database.password" = "<pwd>",
- Save your changes and restart the platform.
This page has no comments.