Zoomdata Version

Backing Up and Restoring the Metadata Store

Before upgrading your Zoomdata server, Zoomdata recommends that you back up your PostgreSQL metadata. This metadata contains refresh schedule data, object information for your environment (such as sources, dashboards, and visualization definitions), and aggregated ResultSets.

Backing Up the Metadata Store

To back up the metadata store:

  1. From your terminal, SSH to your Zoomdata server.

  2. Stop all microservices. For appropriate commands based on your operating system, see Stopping Zoomdata Microservices.

  3. Navigate to the /etc/zoomdata directory and create a backup folder:

    mkdir backups
  4. Navigate to the backups directory.

  5. Perform an SQL dump of Zoomdata databases by entering the following commands:

    sudo -u postgres pg_dump zoomdata > zoomdata				
    sudo -u postgres pg_dump zoomdata-upload > zoomdata-upload
    sudo -u postgres pg_dump zoomdata-keyset > zoomdata-keyset
  6. Restart all Zoomdata microservices. For appropriate commands based on your OS, see Starting Zoomdata Microservices.

Restoring the Metadata Store

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

To restore the metadata store:

  1. From your terminal, SSH to your Zoomdata server.

  2. Stop all Zoomdata microservices. For appropriate commands based on your OS, see Stopping Zoomdata Microservices.

  3. Navigate to your backup directory and enter the following commands:

    sudo -u postgres psql zoomdata < zoomdata				
    sudo -u postgres psql zoomdata-upload < zoomdata-upload
    sudo -u postgres psql zoomdata-keyset < zoomdata-keyset
  4. Restart all Zoomdata microservices. For appropriate commands based on your OS, see Restarting Zoomdata Microservices.

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

Was this topic helpful?