This topic describes how to view backup data and modify backup settings in AnalyticDB for PostgreSQL.
View and modify backup policies
- Log on to the AnalyticDB for PostgreSQL console.
- In the upper-left corner of the console, select a region.
- Find the instance that you want to manage and click the instance ID.
In the left-side navigation pane, click Backup and Restoration.
On the Backup and Restoration page, click the Backup Settings tab to view backup settings.
To modify the backup settings, click Modify Backup Settings.
In the Backup Settings panel, configure the parameters based on the instance version.
The following table describes the parameters for AnalyticDB for PostgreSQL V6.0.
Parameter
Description
Data Backup Retention Period (Days)
The retention period of data backups. Unit: day. Valid values: 1 to 7.
Data backups can be retained for up to seven days during public preview.
Data Backup Cycle
The backup cycle. Select at least one day of the week for data backup.
Data Backup Time
The time range within which you want to create a data backup. Example: 05:00-06:00. We recommend that you back up data during off-peak hours.
Restore Point Settings
Specifies whether to enable point-in-time restore.
If this feature is disabled, data cannot be restored by point in time.
Restore Point Frequency
The frequency at which you want to perform point-in-time restore. Valid values:
Hourly
Every 2 Hours
Every 4 Hours
Every 8 Hours
ImportantThe availability of restore points in time for an AnalyticDB for PostgreSQL V6.0 instance is determined by whether the mechanism of proactively discarding xlog archiving is triggered for instance nodes. For more information about the mechanism of proactively discarding xlog archiving, see the description of log backup in the "How it works" section of the "Overview" topic.
The following table describes the parameters for AnalyticDB for PostgreSQL V7.0.
Parameter
Description
Data Backup Retention Period (Days)
The retention period of data backups. Unit: day. Valid values: 1 to 7.
Data backups can be retained for up to seven days during public preview.
Data Backup Cycle
The backup cycle. Select at least one day of the week for data backup.
Data Backup Time
The time range within which you want to create a data backup. Example: 05:00-06:00. We recommend that you back up data during off-peak hours.
Data Backup Frequency Settings
Specifies whether to enable high-frequency backup and restoration.
Data Backup Frequency
The frequency at which you want to perform data backup. Valid values:
Hourly
Every 2 Hours
Every 4 Hours
Every 8 Hours
Click OK.
View base backup sets
- Log on to the AnalyticDB for PostgreSQL console.
- In the upper-left corner of the console, select a region.
- Find the instance that you want to manage and click the instance ID.
In the left-side navigation pane, click Backup and Restoration.
On the page that appears, click the Data Backup tab to view base backup sets.
Base backup data indicates a full copy of all database data. Base backup data is stored in Object Storage Service (OSS) and retained for seven days by default.
The Data Backup tab displays a copy of base backup data in each row, including Backup Start Time, Backup End Time, Backup Status (Success or Failure), Backup Size, and Consistency Point in Time. Consistency Point in Time indicates the point in time to which you can restore instance data to ensure data consistency among databases.
View restore points in time
AnalyticDB for PostgreSQL V6.0 allows you to view restore points in time.
- Log on to the AnalyticDB for PostgreSQL console.
- In the upper-left corner of the console, select a region.
- Find the instance that you want to manage and click the instance ID.
In the left-side navigation pane, click Backup and Restoration.
On the Backup and Restoration page, click the Restore Points tab.
On the Restore Points tab, view restore points in time.
A restore point in time indicates the point in time to which you can restore instance data.
The Restore Points tab displays the name and timestamp of a restore point in time in each row. You can restore instance data to a restore point in time.
ImportantThe availability of restore points in time for an AnalyticDB for PostgreSQL V6.0 instance is determined by whether the mechanism of proactively discarding xlog archiving is triggered for instance nodes. For more information about the mechanism of proactively discarding xlog archiving, see the description of log backup in the "How it works" section of the "Overview" topic.
View log backups
- Log on to the AnalyticDB for PostgreSQL console.
- In the upper-left corner of the console, select a region.
- Find the instance that you want to manage and click the instance ID.
In the left-side navigation pane, click Backup and Restoration.
On the Backup and Restoration page, click the Log Backup tab.
On the Log Backup tab, view log backups.
Log files record all data changes to databases. An instance can be restored to a previous state by using its corresponding log files. All log files are stored in OSS.