Restoring an Encyclopedia volume using pg_restore
Alternatively, you can restore an Encyclopedia volume schema using the command‑line version of pg_restore. The following example duplicates the restore operations performed in the previous section using the graphical PostgreSQL administration tool, pgAdmin. You do not need to do both activities.
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 an Encyclopedia volume schema:
pg_restore -h mydbhost -p 8432 -U postgres -d db_name
ac_corp_schema.dmp
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:\Program Files (x86)\Actuate\iHub2\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 iserver --clean --verbose "C:\Actuate\iHub\encyc_backup\iserver.backup"
Press Enter.
4 Type the postgres superuser password. The administrator specified this password in PostgreSQL Database Information during the iHub installation procedure. Press Enter.
pg_restore executes, writing status messages to the command prompt.
Take the Encyclopedia volume online by performing the following tasks.
How to take the Encyclopedia volume online
1 Log in to Configuration Console. On the simple view, choose Advanced view. Choose Volumes.
2 On Volumes, take the volume online, as shown in
Figure 10‑13.
Figure 10‑13 Taking the volume online
More information about backing up and restoring an Encyclopedia volume schema using the PostgreSQL pg_dump and pg_restore utilities is available at:
http://www.postgresql.org/docs/8.4/static/backup.html
