Page tree

Release 8.2.2



You should change the passwords for the Alteryx® databases immediately after installing the software.

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
  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>';
    ALTER ROLE trifactaauthorizationservice with PASSWORD '<new_pwd>';
    ALTER ROLE trifactaorchestrationservice with PASSWORD '<new_pwd>';
    ALTER ROLE trifactaoptimizerservice with PASSWORD '<new_pwd>';
    ALTER ROLE trifactasecuretokenservice with PASSWORD '<new_pwd>';
    ALTER ROLE trifactaconnectorconfigservice with PASSWORD '<new_pwd>';
  3. Exit psql:


Change in Alteryx configuration

  1. You can apply this change through the Admin Settings Page (recommended) or trifacta-conf.json. For more information, see Platform Configuration Methods.

  2. Modify the user and password properties for any of the following databases:

    Database NameParameter area

    Alteryx database

    Jobs database
    Scheduling database
    Time-based Trigger database
    Configuration Service database

    Artifact Storage Service database

    Job Metadata Service databasejob-metadata-service.database.*
    Authorization Service databaseauthorization-service.database.*
    Orchestration Service databaseorchestration-service.database.*
    Optimizer Service databaseoptimizer-service.database.*
    Secure Token Service databasesecure-token-service.database.*
    Connector Configuration Service databaseconnector-configuration-service.database.*

    For more information, see Database Parameter Reference.

  3. Save your changes and restart the platform.

This page has no comments.