Create DBs and Users

PostgreSQL

Run the following script, which builds the four databases and specifies the appropriate roles (users) for each database, based on the parameters you have specified in  and in the pg_hba.conf:

NOTE: This script must be run as the root user or via sudo superuser.

/opt/trifacta/bin/setup-utils/db/trifacta-create-postgres-roles-dbs.sh

MySQL

Run the following script, which builds the four databases and specifies the appropriate roles (users) for each database, based on the parameters you have specified in :

NOTE: This script must be run as the root user or via sudo superuser.

/opt/trifacta/bin/setup-utils/db/trifacta-create-mysql-users-dbs.sh -u <MySql_admin_username> -w <MySql_admin_password>

where:

Backup

For more information on backup recommendations and commands, see Backup and Recovery in the Admin Guide.

Configure Non-Default Database Connections

If you have used non-default values for the username, password, host, or port value for either database, you must update platform configuration. For more information, see Database Parameter Reference.