Backup and Recovery

...

This section provides overview information on the key data and metadata that should be managed by your enterprise backup and recovery policies.

Info
NOTE: This section covers how to perform a basic cold backup of the product. Hot backups are not supported.

Warning
All backups should be performed in accordance with your enterprise's backup and recovery policies.

Stop All Services

Before you begin, the

D s platform

and databases should be stopped. See Start and Stop the Platform.

The following directories on the

D s node

should be backed up on a regular basis:

...

Database Name	DatabaseId	Description
Trifacta DB	`trifacta`	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.

For more information on setting up these databases, see Install Databases.

...

Code Block
pg_dump trifactaconfigurationservice > trif_confservDB_bkup_<date>.sql

Artifact Storage DB:

Code Block
pg_dump trifactaartifactstorageservice > trif_artifactstorageservDB_bkup_<date>.sql

...

Code Block
mysqldump trifactaconfigurationservice > trif_confservDB_bkup_<date>.sql

Artifact Storage DB:

Code Block
mysqldump trifactaartifactstorageservice > trif_artifactstorageservDB_bkup_<date>.sql

You can schedule nightly execution of these backups using a third-party scheduler such as cron.

You can restart the

D s platform