Reviewing Backup Details
Details displayed on dialogs related to backup and restore will vary based on the backup provider you selected during database provisioning (opens in a new tab).
You can use the pgEdge Backups
page to review and manage database backups; the Backups
page also provides access to links that allow you to perform an ad hoc backup or restore. To open the Backups
page, select a database name in the navigation panel and select the Backups
node from the navigation tree.
At the top of the Backups
dialog, the header provides information about the selected database:
- The Database name.
- The length of time since the database was created.
- The name of the cluster in which the database resides.
- The PostgreSQL version used by the database.
- The version of Spock used by the database.
In the Backup Configuration
panel, a pane for each database in your cluster displays configuration details for the database; select the more details
link to view extended backup detail including:
- The node number, node name, and region identifier.
- The backup schedules for the database.
- The repository status.
- The length of time since the last backup.
- The name of the Backup Store used by the database.
- How long backups are retained for.
- The storage type of the Backup Store.
- The repository ID in which the backups are stored.
The Backups
table displays the backups currently stored for the database:
The columns displayed in the Backups
table will vary depending on your backup provider (opens in a new tab):
- Use the tabs across the top of the table to select the node you wish to see the backups for.
- The
Label
column (if you're using pgBackRest) orName
column (if you're using pg_dump) contains the backup identifier. - The
Status
column displaysSUCCESSFUL
if the backup completed successfully. - The
Type
column identifies the backup method;Full
if the backup was a complete backup,Incremental
if the backup only contains those changes that occurred since the last incremental backup, andDifferential
if it was a backup of only those changes that occurred since the last full backup. - The
Backup Size
column displays the storage size of the database at the time of the backup. - The
Database Size
column displays the storage size of the database. - The
Created At
column displays the date and time the backup started. - The
Finished At
column displays the date and time the backup completed. - If you use pg_dump for your backups, you can use the context menu to the left of a backup name to access backup management options:
- Select
Download
to download the backup archive. - Select
Delete
to delete the backup archive.
- Select
Note: If a pgBackRest backup fails, details are written to the tricorder log files. pg_dump backups that fail to complete are not displayed in the Backups
table or written to log files.