Restoring BIRT iHub System using pg_restore
To restore a backed-up BIRT iHub System, perform the following tasks:
*Take BIRT iHub System offline.
*Delete the acserverconfig.xml file in AC_SERVER_HOME\shared\config and the volume data folder in AC_SERVER_HOME\shared.
*Copy the backed‑up acserverconfig.xml file to AC_SERVER_HOME\shared\config form the backup folder and the volume data folder from the backup folder to AC_SERVER_HOME\shared.
*Restore the BIRT iHub system and volume metadata using the PostgreSQL pg_restore utility.
*Take BIRT iHub System online.
Alternatively, the administrator can restore an individual volume by selectively backing up and restoring only the related volume schema and data.
To begin a restore operation, take BIRT iHub System or the individual volume offline.
How to restore the backed‑up data folders
1 In Windows Explorer, navigate to AC_SERVER_HOME\shared\config.
2 Select acserverconfig.xml, right-click, and choose Delete. Confirm the deletion.
3 In AC_SERVER_HOME,\shared, delete the volume folder, for example, AC_SERVER_HOME\shared\storage. Confirm the deletion.
4 In Windows Explorer, navigate to the following location:
C:\Actuate3\BIRTiHubVisualization\backup
Select acserverconfig.xml, right-click, choose Copy, and copy this file to AC_SERVER_HOME\shared\config.
5 In C:\Actuate3\BIRTiHubVisualization\backup, right-click the volume folder, for example, storage. Choose Copy, and copy this folder to AC_SERVER_HOME\shared.
Restore BIRT iHub System schemas using the command‑line version of pg_restore. The pg_restore utility runs using arguments similar to the pg_dump utility.
The following example shows a typical pg_restore command used to import the contents of a backup file to the BIRT iHub System database:
pg_restore -h dbhost -p 8432 -U postgres -d db_name_ihub_ihub.backup
Run pg_restore from the command line by performing the following tasks.
How to run pg_restore from a command prompt
1 Open a command prompt.
2 Navigate to the following location:
C:\Actuate3\BIRTiHubVisualization\modules\BIRTiHub\iHub
\postgresql\bin
3 Enter the following command. Substitute your machine name for urup in this example:
pg_restore.exe --host urup --port 8432 --username postgres
‑‑dbname ihub --clean --verbose "C:\Actuate3
\BIRTiHubVisualization\backup\ihub.backup"
Press Enter.
4 If prompted, type the postgres superuser password. Press Enter.
pg_restore executes, writing status messages to the command prompt.
Take BIRT iHub System or. alternatively, the individual volume online.
More information about backing up and restoring a volume schema using the PostgreSQL pg_dump and pg_restore utilities is available at:
http://www.postgresql.org/docs/9.2/static/backup.html