...
| Database Name | DatabaseId | Description |
|---|---|---|
| Main DB |
| Stores users and metadata for flows, including datasets, and recipes. |
| Jobs DB | trifacta-activiti | Stores and maintains job execution status and details. |
| Scheduling DB | trifactaschedulingservice | Stores metadata for scheduled jobs. |
| Time-based Trigger DB | trifactatimebasedtriggerservice | Additional database required for scheduled jobs. |
| Configuration Service DB | trifactaconfigurationservice | Stores configuration settings for the workspace. |
| Artifact Storage Service DB | trifactaartifactstorageservice | Stores feature usage data such value mappings for the standardization feature. |
| Job Metadata Service DB | trifactajobmetadataservice | Stores metadata on job execution. |
For more information on setting up these databases, see Install Databases.
...
| Code Block |
|---|
/usr/pgsql-9.6/bin/pg_dump /usr/pgsql-9.6/bin/psql |
Ubuntu:
| Code Block |
|---|
/usr/lib/postgresql/9.6/bin/pg_dump /usr/lib/postgresql/9.6/bin/psql |
...
| Info |
|---|
NOTE: The following commands are for PostgreSQL 9.6 for all supported operating systems. For specific commands for other versions, please see the database documentation. |
| Tip |
|---|
Tip: You may see performance improvements by backing up and restoring using .TAR files. However, there is a risk that .TAR support could change in the future. For more information, please see the PostgreSQL documentation. |
Trifacta DB:
| Code Block |
|---|
pg_dump trifacta > trif_triDB_bkp_<date>.sql |
...
