Online Help for Administrators > Monitoring SHR > Monitoring the data processes > Back up and restore SHR PostgreSQL management database

Back up and restore SHR PostgreSQL management database

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:

  1. Stop the PMDB Platform Timer service.
  2. Stop the PMDB Platform Collection service.
  3. Wait for all the loaded data processing stream processes to stop running.
  4. Check the status of the streams on the Data Processing page of the Administration Console. You can also check the status by typing the following command:

    abcMonitor -stream ID=ALL, state=active

  5. Back up the database using a PostgreSQL database backup utility.

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:

  1. Stop the PMDB Platform Timer service.
  2. Stop the PMDB Platform Collection service.
  3. Wait for all the loaded data processing stream processes to stop running.
  4. Check the status of the streams on the Data Processing page of the Administration Console. You can also check the status by typing the following command:

    abcMonitor -stream ID=ALL, state=active

  5. Restore the Management database using a PostgreSQL restore utility.
  6. Restart the PMDB Platform Collection Service and the PMDB Platform Timer service after the restore operation is complete.

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.

 


© 2010 - 2013 Hewlett-Packard Development Company, L.P.