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 Download to download the backup file.
• Select Delete to 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:

• Take a backup of one or more nodes
• Restore a backup into one or more nodes
• Delete the database (opens in a new tab)

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 Nodes drop-down to select one or more nodes to be included in the backup.
• Specify a name for the backup archive in the Backup Name field. 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 Name drop-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.