This website stores cookies about how you interact with our website and allow us to remember you. To find out more about the cookies we use, see our Privacy Policy. X
We have moved our documentation to our main site. To access all technical documentation, see our Support Portal.

Important Notice

You are opening an old technical document that may not contain the most up-to-date information. Access all our technical documentation in the new Synergy SKY Support Portal.

This site is only being used for ticketing.

Close

Skip to main content

How to: Back Up and Restore the Database

Brian Greer
  • Updated

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

 

Step by Step Guide

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

 

Back Up Database

  1. Select option '1 Back up database'mceclip2.png

  2. Once selected, the database backup will start, and the system will provide a progress overviewmceclip3.png
  1. 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.  mceclip3.png
  2. 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'mceclip4.png
  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.
    mceclip5.png
  5. Once the Retore database process has completed, press Enter to restart VM.