The SHR PostgreSQL management database stores three types of information:
Backing up the database
You might want to back up the management database for data recovery purposes. To back up the database, follow these steps:
abcMonitor -stream ID=ALL, state=active
Restoring the database
You might want to restore the management database to get the historical step execution status details. To restore the database, follow these steps:
abcMonitor -stream ID=ALL, state=active
After the services are started, the data processing framework automatically starts executing the restored steps from where it stopped, handling the Step status automatically. Restoration of the old database also results in old data for the stage_control and data audit tables. However, these tables are automatically updated by the framework within a couple of hours.