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.

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 '4 Advanced setup menu'

3. Select '2 Backup/Restore data'

Back Up Database

1. Select '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 summary. The summary shows the file name and size of the backup, as well as a download link to retrieve the backup file.

Restore Database Backup

In order to restore an database backup, you will need to follow the following process:

1. From the main menu, select '4 Advanced setup menu'
2. Then select '2 Backup/Restore data'
3. Select '2 Restore database'
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.