Backing up BIRT iHub System using pg

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 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:\Actuate
\BIRTiHubVisualization\backup\ihub.backup" "dbname"

This pg_dump command example uses the following arguments:

Specifies the host name of the machine where the PostgreSQL server is running, such as dbhost.

Specifies the port where the server listens for connection requests.

Specifies the user name for the connection to the PostgreSQL server, such as postgres.

Specifies the output format. The value custom creates a compressed archive that can be used as input to pg_restore.

Replace this string in the example with the database name, such as ihub.

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:

More information about setting up a scripted backup using a .pgpass file is available at:

Back up BIRT iHub System metadata using pg_dump by performing the following tasks.

C:\Actuate\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:\Actuate
\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.

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.

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:\Actuate\BIRTiHubVisualization\modules\BIRTiHub\iHub\shared
\config

2 Select acserverconfig.xml, right click, and choose Copy. Copy the file to the backup location. For example:

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: