Backing up BIRT iHub System using pg_dump
To back up BIRT iHub System using the PostgreSQL pg_dump utility, perform the following tasks:
*Create a folder to contain the metadata and volume data backup files.
*Back up BIRT iHub System metadata using the pg_dump utility.
*Back up the acserverconfig.xml file and volume data folders to the backup folder.
Create a folder to contain the metadata, configuration file, and volume data backup files outside the BIRT iHub data installation environment. To provide protection against single‑point media failure, it is best to store the backup files at a storage location that is physically separate from the BIRT iHub System and volume data locations.
The following example shows a typical pg_dump command used to export the contents of the iHub cluster and volume schemas to a backup file:
pg_dump.exe --host dbhost --port 8432 --username "postgres"
--format custom --blobs --verbose --file "C:\Actuate3
\BIRTiHubVisualization\backup\ihub.backup" "dbname"
This pg_dump command example uses the following arguments:
*host
Specifies the host name of the machine where the PostgreSQL server is running, such as dbhost.
*port
Specifies the port where the server listens for connection requests.
*username
Specifies the user name for the connection to the PostgreSQL server, such as postgres.
*format
Specifies the output format. The value custom creates a compressed archive that can be used as input to pg_restore.
*blobs
Specifies including blob data types.
*verbose
Specifies the level of command-line status messages.
*file
Specifies the output file, such as ihub.backup.
*dbname
Replace this string in the example with the database name, such as ihub.
*n or name
Species the schema name. Use multiple ‑n arguments to specify a list. Use wildcard notation to specify a character pattern, such as ac_*. to specify all volumes names that start with the prefix ac_. If ‑n is not specified, pg_dump exports all non‑system schemas.
Alternatively, run the command at the volume schema level to back up individual volume schema to a separate archive. To run a backup using a script, set up auto‑login using a .pgpass file. The file should contain connection information in the following format:
hostname:port:database:username:password
More information about setting up a scripted backup using a .pgpass file is available at:
http://www.postgresql.org/docs/9.2/static/libpq-pgpass.html
Back up BIRT iHub System metadata using pg_dump by performing the following tasks.
How to run pg_dump from a command prompt
1 Open a command prompt.
2 Navigate to the following location:
C:\Actuate3\BIRTiHubVisualization\modules\BIRTiHub\iHub
\postgresql\bin
3 Execute the following command. Substitute your machine name for urup in this example:
pg_dump.exe --host urup --port 8432 --username "postgres" --format custom --blobs --verbose --file "C:\Actuate3
\BIRTiHubVisualization\backup\ihub.backup" "ihub"
This operation backs up the entire ihub database. If the ‑n argument specifying a specific schema or list of schemas is not specified, pg_dump exports all database schemas. Alternatively, you can back up only one volume schema by using the ‑n argument to specify a particular schema.
4 If prompted to enter a password, type the postgres superuser password.
pg_dump executes, writing status messages to the command prompt.
After backing up the BIRT iHub System metadata, back up the acserverconfig.xml file and volume data directories to the backup directory by performing the following tasks.
How to back up the volume data folders
1 Open Windows Explorer and navigate to the config folder that contains acserverconfig.xml file. In a default BIRT iHub installation, this file is located in AC_SERVER_HOME\shared\config. For example:
C:\Actuate3\BIRTiHubVisualization\modules\BIRTiHub\iHub
\shared\config
2 Select acserverconfig.xml, right click, and choose Copy. Copy the file to the backup location. For example:
C:\Actuate3\BIRTiHubVisualization\backup
3 Navigate to the folder or folders that contain volume data files, such as AC_SERVER_HOME\shared\storage. Right-click the folder, and choose Copy. Copy this folder to the backup location. For example:
C:\Actuate3\BIRTiHubVisualization\backup