Managing Backups
You can use the pgEdge Backups dialog to take, restore, and manage backups of your cloud database. To open the Backups dialog, select the Backups node from the navigation tree in the left-side panel.
pgEdge Cloud databases are automatically backed up once every 24 hours. The backup is a pg_dump (opens in a new tab) archive of the commands used to create or recreate your database.
Use the context menu to the left of a backup name to access backup management options:
- Select
Downloadto download the backup file. - Select
Deleteto delete the backup.
Database management options related to backup and restore actions are available on the Actions drop-down in the upper-right corner of the Backups dialog.
Use Actions menu options to:
Taking a Backup
To take a database backup, select Backup from the drop-down Actions menu in the upper-right corner of the Backups dialog.
When the Backup Database popup opens:
- Use the
Target Nodesdrop-down to select one or more nodes to be included in the backup. - Specify a name for the backup archive in the
Backup Namefield. The name will be appended with a dot, followed by the node name and backup type (i.e..n2.full.backup).
Use the Reset icon to clear the fields, or select the Backup Database button to start the backup.
Restoring a Backup
To restore from backup, select Restore from the drop-down Actions menu in the upper-right corner of the Backups dialog.
- Use the
Backup Namedrop-down to select the backup you wish to restore. - Select one or more nodes on which the backup will be restored; the restoration process will drop and recreate the schema on the target nodes, restore data from the backup, and re-configure Spock to restart replication.
- Check the box next to
Restore schema only?to restore the schema without adding data (recreating empty tables).
Use the Reset icon to clear the fields, or select the Restore Database button to start restoring the backup.