Page tree

 

Contents:


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  trifacta-conf.json 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  trifacta-conf.json:

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:

  • -u = MySQL admin username, which is usually root.
  • -w = MySQL admin password

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.

This page has no comments.