Administer > Administer ITBA > System Administrator > Business Analytics Back Up

Business Analytics Back Up

It is critical that you backup your postgreSQL database, Content Packs, configuration files, logs and configuration settings so that you can rebuild your IT Business Analytics solution and content in circumstances such as the following:

  • When you need to recover from a total disaster recovery scenario.

  • Business Analytics server failed but the Vertica Database server is fully functioning

ClosedWhat to Back Up

HPE recommends that you back up the following resources that may be used when one of the above scenarios occurs.

PostgreSQL database:

  1. Log on to the ITBA server with the user name you used to setup ITBA
  2. Go to $HPBA_HOME/pgsql/bin
  3. Run the command ./pg_dump -d xs_mng -U xsadmin > [backup filename, such as /tmp/xs_mng.bak]

Content Packs

Back up the Content Pack folder $HPBA_HOME/ContentPacks.

ClosedGeneral Backup Guidelines

It is recommended that you use the following backup and restore guidelines:

  • Your database administrator should back up critical data and Content Packs on a regular basis.

  • Database backups should consist of a weekly full database backups, and daily differential backups.

  • Backups should be periodically verified by restoring a copy onto a test system.

  • Start scheduled backups before running the daily ETLs.

  • Perform full backups in off-peak times.