Zoomdata Version

Backing Up and Restoring the Metadata Store

Overview

Before upgrading your Zoomdata server, it is recommended to backup your PostgreSQL metadata. This metadata contains your scheduler data, object information for your environment (such as sources, dashboards, and visualization definitions), and aggregated resultsets.

Backing up metadata store

Do the following: 

  1. From your terminal, SSH to your Zoomdata server.
  2. Stop all services. For appropriate commands based on your OS, see Stopping Zoomdata Services.
  3. Navigate to the /etc/zoomdata directory and create a backup folder:
    mkdir backups
  4. Navigate in to the backups directory.
  5. Perform a SQL dump of the Zoomdata and scheduler databases by entering the following commands:
    sudo -u postgres pg_dump zoomdata > zoomdata
    sudo -u postgres pg_dump zoomdata-scheduler > zoomdata-scheduler
  6. Restart all Zoomdata services. For appropriate commands based on your OS, see Starting Zoomdata Services.

Restoring the Metadata Store

Prior to restoring the metadata, ensure that the target PostgreSQL source is clean.

Do the following:

  1. From your terminal, SSH to your Zoomdata server.
  2. Stop all Zoomdata services. For appropriate commands based on your OS, see Stopping Zoomdata Services.
  3. Navigate to your backup directory and enter the following commands:
    sudo -u postgres psql zoomdata < zoomdata
    sudo -u postgres psql zoomdata-scheduler < zoomdata-scheduler
  4. Restart all Zoomdata services. For appropriate commands based on your OS, see Starting Zoomdata Services.

For more information on backup and restore processes for PostgreSQL, refer to the PostgreSQL documentation.