Before upgrading your Composer server, Composer 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.
To back up the metadata store:
From your terminal, SSH to your Composer server.
Stop all microservices. For appropriate commands based on your operating system, see Stop Composer Microservices.
Navigate to the
/etc/zoomdatadirectory and create a backup folder:
Navigate to the backups directory.
Perform an SQL dump of Composer 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
Restart all Composer microservices. For appropriate commands based on your OS, see Start Composer Microservices.
For more information on backup and restore processes for PostgreSQL, refer to the PostgreSQL documentation.