7.3 Restoring the Database

Restoring an archived database is done by using the pg_restore command. To restore a backup from a bzip2 compressed tar file, use the following command:

bunzip2 db.tar.bz2
pg_restore -d <db_name> db.tar

You can execute pg_restore(1) on the db_host machine or set up the PostgreSQL environment variables according to the database configuration in /opt/iic/conf/global-config.