This topic explains how to configure backup settings and view backup data in AnalyticDB for PostgreSQL, including base backup sets, restore points, and log backups.
Backup types
AnalyticDB for PostgreSQL supports two backup types depending on your instance configuration:
| Type | Description | Supports |
|---|---|---|
| Physical backup | A full copy of all database data. | Point-in-time restore using restore points and log backups |
| Snapshot backup | A snapshot-based copy of your instance data. | High-frequency backup and restoration at configurable intervals |
The backup settings panel shows parameters specific to your instance's backup type.
Usage notes
Schedule backups during off-peak hours to minimize performance impact.
Data backups are retained for up to 7 days during public preview.
For AnalyticDB for PostgreSQL V6.0 instances using physical backup, restore point availability depends on whether the mechanism of proactively discarding xlog archiving is triggered on instance nodes. See How it works in the backup and restoration overview for details.
Configure backup settings
Log on to the AnalyticDB for PostgreSQL console.
In the upper-left corner, select a region.
Find the instance and click its ID.
In the left-side navigation pane, click Backup and Restoration.
On the Backup and Restoration page, click the Backup Settings tab.
Click Modify Backup Settings.
In the Backup Settings panel, configure the parameters for your instance type.
ImportantFor AnalyticDB for PostgreSQL V6.0 instances, restore point availability depends on whether the mechanism of proactively discarding xlog archiving is triggered for instance nodes. See How it works in the backup and restoration overview.
Physical backup instances
Parameter Description Data Backup Retention Period (Days) How long data backups are kept. Valid values: 1–7. Data Backup Cycle The days of the week on which backups run. Select at least one day. Data Backup Time The time window for backup creation, for example, 05:00–06:00. Select an off-peak window. Restore Point Settings Enables or disables point-in-time restore. When disabled, data cannot be restored to a specific point in time. Restore Point Frequency How often restore points are created. Valid values: Hourly, Every 2 Hours, Every 4 Hours, Every 8 Hours. Snapshot backup instances
Parameter Description Data Backup Retention Period (Days) How long data backups are kept. Valid values: 1–7. Data Backup Cycle The days of the week on which backups run. Select at least one day. Data Backup Time The time window for backup creation, for example, 05:00–06:00. Select an off-peak window. Data Backup Frequency Settings Enables or disables high-frequency backup and restoration. Data Backup Frequency How often backups are created when high-frequency backup is enabled. 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, select a region.
Find the instance and click its ID.
In the left-side navigation pane, click Backup and Restoration.
Click the Data Backup tab.
The Data Backup tab lists all base backup sets. Base backup data is a full copy of all database data, stored in OSS and retained for 7 days by default. Each row shows the following information:
| Column | Description |
|---|---|
| Backup Start Time | When the backup job started. |
| Backup End Time | When the backup job finished. |
| Backup Status | The result of the backup job: Success or Failure. |
| Backup Size | The size of the backup set. |
| Consistency Point in Time | The point in time to which you can restore instance data to ensure data consistency across databases. |
View restore points
Restore points are available only for instances that support physical backup.
Log on to the AnalyticDB for PostgreSQL console.
In the upper-left corner, select a region.
Find the instance and click its ID.
In the left-side navigation pane, click Backup and Restoration.
Click the Restore Points tab.
The Restore Points tab lists all available restore points. Each row shows the name and timestamp of a restore point. Use these timestamps when restoring an instance to a specific point in time.
For AnalyticDB for PostgreSQL V6.0 instances, restore point availability depends on whether the mechanism of proactively discarding xlog archiving is triggered for instance nodes. See How it works in the backup and restoration overview.
View log backups
Log on to the AnalyticDB for PostgreSQL console.
In the upper-left corner, select a region.
Find the instance and click its ID.
In the left-side navigation pane, click Backup and Restoration.
Click the Log Backup tab.
Log files record all data changes to databases. An instance can be restored to a previous state using its log files. All log files are stored in OSS.
FAQ
Why are some restore points unavailable for my V6.0 instance?
For AnalyticDB for PostgreSQL V6.0 instances, the mechanism of proactively discarding xlog archiving may be triggered on instance nodes, which affects restore point availability. See How it works in the backup and restoration overview for details.
Why can I not see the Restore Points tab?
The Restore Points tab is available only for instances that support physical backup. Snapshot backup instances do not support point-in-time restore.