Change Database Passwords for PostgreSQL

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

Change in Database Server

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. Default usernames are listed for each database. 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 trifactaactiviti WITH PASSWORD '<new_pwd>';
   ALTER ROLE trifactatimebasedtriggerservice with PASSWORD '<new_pwd>';
   ALTER ROLE trifactaschedulingservice with PASSWORD '<new_pwd>';
   ALTER ROLE trifactaconfigurationservice with PASSWORD '<new_pwd>';
   ALTER ROLE trifactaartifactstorageservice with PASSWORD '<new_pwd>';
   ALTER ROLE trifactajobmetadataservice with PASSWORD '<new_pwd>';

3. Exit psql:

   \q
   exit