Before doing any reconfiguration or upgrade of the Conferencing software, we recommend that you perform a backup of your existing database.
The system automatically backs up the database on a daily basis. The backups can be found in /var/iic/db-backups on the db-host (as defined in /opt/iic/conf/global-config). Each backup is a tar(1) archive compressed using the bzip2(1) utility. The current daily backup is called db.tar.bz2.
You can also back up the database at any arbitrary time using the pg_dump(1) utility. The state of the database in the backup is that of all committed transactions at the time pg_dump(1) is run. Any updates done after the backup is started are ignored.
The following command line shows how to dump the contents of the database to a tar(1) archive named db.tar:
pg_dump -b -F t -f db.tar <db_name>
bzip2 db.tar
You can either execute pg_dump on the db_host machine or set up the PostgreSQL environment variables according to the database configuration in /opt/iic/conf/global-config.
Restoring an archived database is done by using the pg_restore command. To restore a backup in a bzip2 compressed tar file, the following command line can be used:
bunzip2 db.tar.bz2 pg_restore -d <db_name> db.tar
You can either 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.