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:
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.