|Main DB||Stores users and metadata for flows, including datasets, and recipes.|
|Jobs DB||Stores and maintains job execution status and details.|
|Scheduling DB||Stores metadata for scheduled jobs.|
|Time-based Trigger DB||Additional database required for scheduled jobs.|
|Configuration Service DB||Stores configuration settings for the workspace.|
|Artifact Storage Service DB|
Stores feature usage data such value mappings for the standardization feature.
|Job Metadata Service DB||Stores metadata on job execution.|
For more information on setting up these databases, see Install Databases.
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: 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.
pg_dump trifacta > trif_triDB_bkp_<date>.sql