Change Database Passwords

Please complete the following steps to change the passwords for the  Designer Cloud powered by Trifacta platform  users of the Trifacta databases.

Change via SQL:

1. If you have not done so already, switch to the Postgres user and launch psql:
   
   

   sudo su - postgres
   psql

2. For each database, change the default password, where trifacta and trifacta-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>';

3. Exit psql:
   
   

   \q
   exit

Change via Trifacta configuration:

1. 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: 

   1. Trifacta database: 

      "webapp.db.username" = "<user>",
      "webapp.db.password" = "<pwd>",

   2. Jobs database: 

      "batch-job-runner.db.username" = "<user>",
      "batch-job-runner.db.password" = "<pwd>",

   3. Scheduling database: 

      "scheduling-service.database.user" = "<user>",
      "scheduling-service.password.password" = "<pwd>",

   4. Time-based trigger database: 

      "time-based-trigger-service.database.user" = "<user>",
      "time-based-trigger-service.database.password" = "<pwd>",

2. Save your changes and restart the platform.