Using RDBMS and file system backup utilities
The administrator must perform the Encyclopedia volume metadata backup using the tools provided or supported by the RDBMS. Copying the physical files of a database at the operating system level while an RDBMS is running does not create a valid backup.
Most RDBMS backup tools can be scripted and run while iHub is using the database. PostgreSQL, Oracle, Microsoft SQL Server, and DB2 also provide graphical administration tools in addition to command‑line tools. This chapter provides instructions on how to perform a backup in the PostgreSQL RDBMS environment as a reference example. For more information on using other RDBMS systems and tools to back up and restore an Encyclopedia volume, see the vendor documentation.
How to perform an Encyclopedia volume backup
To back up an Encyclopedia volume, perform the following tasks:
1 Make sure that the autoarchive file purging process is not running.
2 Make an online backup of the volume schema using the tools provided by the RDBMS.
3 Back up the volume data files using the tools available in the operating system environment.