How to: Back Up and Restore the Database

Introduction

The Synergy SKY software stores all its data in a PostgresSQL database. The platform comes with no automated process for performing backups. 

This document is the procedure to do a failover activation of the passive server as part of the HA configuration.
https://support.synergysky.com/hc/en-us/article_attachments/4404018151698/Synergy_SKY_Suite___Active-Passive_Replication_and_Manual_Failover-v2.pdf 

HA 

• Backup the skeleton config from the passive server and save for later access
• Once restored below, to revert back, simply reapply the skeleton config to the passive server.

Prerequisites

None

Configuration Reference

• Configuring the Synergy SKY Platform

Step by Step Guide

1. Log on to the Synergy SKY server via SSH
2. Select option '6 Backup/restore'

Back Up Database

1. Select option '1 Back up database'
   
   
2. Once selected, the database backup will start, and the system will provide a progress overview

3. Once the backup process has completed, you will see a backup summary. The summary shows the file name and size of the backup. A link with login credentials is provided to download a copy of the backup file. 
4. Type 'skysetuptool' to return to Setup menu

Restore Database Backup

In order to restore a database backup, you will need to follow the process below:

1. From the Setup menu, select option '6 Backup/restore'
2. Then select option '2 Restore database'
3. Select option '1 Backup/Restore data'
4. Make sure that your backup file is uploaded to the server as specified in the prompt below. If it isn't already, upload it and then refresh the list of available backups.
   
5. Once the Retore database process has completed, press Enter to restart VM.