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 a volume in the out-of-the-box (OOTB) PostgreSQL RDBMS environment, the administrator performs the following operations:

Note that a backup of a PostgreSQL database is not portable across all operating systems.

To restore BIRT iHub System in the OOTB PostgreSQL RDBMS environment, the administrator performs the following operations:

The following sections describe how to back up and restore a BIRT iHub System that uses the OOTB PostgreSQL database to store the metadata. These demonstrations serve as a detailed reference example. Other supported database systems, such as Oracle provide similar utilities and require comparable operational procedures.