Data backup-AnalyticDB(AnalyticDB)-阿里云帮助中心

This topic explains how to view and configure backup settings for an AnalyticDB for PostgreSQL instance.

Backup settings

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 the backup settings.
To modify the settings, click Modify Backup Settings.

In the Backup Settings panel, configure the backup parameters for your instance.

If your AnalyticDB for PostgreSQL instance supports physical backup, configure the following parameters.

Parameter	Description
Data Backup Retention Period (Days)	Specifies the number of days to retain data backups. Valid values: 1 to 7. During the public preview, backups can be retained for a maximum of 7 days.
Data Backup Cycle	Specifies the days of the week for data backups. You must select at least one day.
Data Backup Time	The time window in which the data backup starts. Example: 05:00-06:00. We recommend that you set this to a time during off-peak hours.
Restore Point Settings	Specifies whether to enable point-in-time restore. If this feature is disabled, you cannot restore the instance to a specific point in time. Use this option with caution.
Restore Point Frequency	Specifies how often restore points are created. The following frequencies are supported: Hourly Every 2 Hours Every 4 Hours Every 8 Hours Important For AnalyticDB for PostgreSQL V6.0 instances, the availability of a restore point depends on whether the mechanism of proactively discarding xlog archiving has been triggered. For more information about this mechanism, see the log backup description in Features.

If your AnalyticDB for PostgreSQL instance supports snapshot backup, configure the following parameters.

Parameter	Description
Data Backup Retention Period (Days)	Specifies the number of days to retain data backups. Valid values: 1 to 7. During the public preview, backups can be retained for a maximum of 7 days.
Data Backup Cycle	Specifies the days of the week for data backups. You must select at least one day.
Data Backup Time	The time window in which the data backup starts. Example: 05:00-06:00. We recommend that you set this to a time during off-peak hours.
Data Backup Frequency Settings	Specifies whether to enable high-frequency backup and restoration.
Data Backup Frequency	Specifies the interval between backups. A new backup begins after the previous one completes. The following frequencies are supported: Hourly Every 2 Hours Every 4 Hours Every 8 Hours

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.
The Data Backup tab displays information about base backup sets.

A base backup set is a complete copy of all data in an instance. These backups are stored in Object Storage Service (OSS) and retained for 7 days by default.

Each row on the Data Backup tab represents a base backup set and displays its Backup Start Time, Backup End Time, Backup Status (Success or Failure), Backup Size, and Consistency Point in Time. The Consistency Point in Time is the latest point to which you can restore the instance from this backup while ensuring data consistency.

Important

You can view restore points only if your AnalyticDB for PostgreSQL instance supports physical backup.

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.
The Log Backup tab displays information about log backups.

Log files record all changes made to the database. During a restore, these log files are used to return the instance to a specific state. All log files required for instance restores are stored in OSS.