Backing up and restoring an Encyclopedia volume that uses a PostgreSQL database
PostgreSQL provides the pgAdmin graphical administration tool or the pg_dump and pg_restore command‑line utilities to back up and restore a database. These PostgreSQL utilities run on the client not the server.
To back up an Encyclopedia volume in the OOTB PostgreSQL RDBMS environment, the administrator performs the following operations:
Backs up Encyclopedia volume metadata using the pgAdmin graphical administration tool or the pg_dump PostgreSQL command‑line utility
Backs up Encyclopedia volume data and configuration files using operating system copy commands
Note that a backup of a PostgreSQL database is not portable across all operating systems.
To restore an Encyclopedia volume in the OOTB PostgreSQL RDBMS environment, the administrator performs the following operations:
Restores Encyclopedia volume metadata using the pgAdmin graphical administration tool or the pg_restore PostgreSQL command‑line utility
Restores Encyclopedia volume data and configuration files using operating system copy commands
The following sections describe how to back up and restore an Encyclopedia volume that uses the OOTB PostgreSQL database to store the metadata. These demonstrations serve as a detailed reference example.