Back Up the Metadata Store

Before upgrading your Composer server, insightsoftware recommends that you back up your PostgreSQL metadata store. The metadata includes refresh schedule data, object information for your environment (such as sources, dashboards, and visual definitions), and aggregated result sets. After the metadata store is backed up, perform the upgrade. If problems arise, you can restore the metadata store from your backup copy, if necessary.

This topic describes how to back up the metadata store. For information about restoring the metadata store, see Restore the Metadata From the Metadata Store Backup.

Back up the metadata store

1. From your terminal, SSH to your server.

2. Stop all microservices. For appropriate commands based on your operating system, see Stop 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 the 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
   sudo -u postgres pg_dump zoomdata-qe > zoomdata-qe

6. Restart all microservices. For appropriate commands based on your OS, see Start Microservices.

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