Monday, October 12, 2015

Backing up Pentaho Server during Crash time.

Backing up the files of the Pentaho Suite:

NOTE: You must quit all Pentaho programs and stop all Pentaho-related services (including the BA Server, DI Server, Pentaho Enterprise Console, and the solution database) before creating backups. Do not start the services backup until it is complete

The easiest way to back up a directory is to create a compressed archive of it. 
  •  Generally on a Windows system you would use the Zip or RAR formats through programs like 7-zip or WinRAR.
  • On Linux, BSD, and Solaris, you would use GNU Tar or bsdtar.

No matter which program you use, you should end up with either one single file that encompasses the entire /pentaho/ directory (for graphical installer and archive deployments), or the /pentaho/ directory plus the pentaho.war file from your application server (for manual deployments).

Backing up the Pentaho Repository:

Using whatever tool you choose depending on your DB (Oracle, MySQL, or PostgreSQL).   Run a backup of the 'Hibernate' and 'Quartz' DB's/Schema's.   


If you have a backup of the /pentaho directory and the DB, you should be able to restore your system.   As to a backup schedule, that is completely up to you and your infrastructure requirements.

Backup of Pentaho 5.x
Steps for taking backup of the content
  1. Log in to the operating system of the server machine as the user that installed Pentaho 5.0.0. Using this user is important to avoid any issues with operating system file permissions.
  2. Stop the Business Analytics server.
  3. Take a complete database backup of the quartz, hibernate, and jackrabbit databases. If you're using Postgresql, use the command-line tool pg_dump in the postgresql bin folder. You will need to authenticate as the main database user for each database (jcr_user for jackrabbit, hibuser for hibernate, and pentaho_user for quartz). For example (from the command-line) - for the jackrabbit database:
"C:\Program Files\pentaho\postgresql\bin\pg_dump" -U jcr_user jackrabbit > %TEMP%\jackrabbit.dmp (Windows)
Or
postgresql/bin/pg_dump -U jcr_user jackrabbit > /tmp/jackrabbit.dmp (*nix)
If you're not using Postgresql, please use the tools provided by your database vendor to take full backups of those databases
4. Take a backup of full bi-server directory.
You can also use the import-export utility to backup content only
Follow the link below to Upload and Download from the BA Repository, Using the import-export utility Download the content to backup.
Posted by at

1 comment:

Subscribe to: Post Comments (Atom)