Backup and restoration (Serverless Pro mode)

Automatic backup policy

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

2. In the left-side navigation pane, click Backup and Restoration.

3. On the Backup and Restoration page, click the Backup Settings tab to view the backup policy.

4. To modify the backup policy, click Modify Backup Settings.

5. In the Backup Settings panel, configure the backup policy. The following table describes the parameters.

   Parameter	Description
   Data Backup Retention Period (Days)	The number of days to retain backups. Valid values: 1 to 7. During the public preview, the maximum backup retention period is 7 days.
   Data Backup Cycle	The days of the week to run backups. You must select at least one day.
   Data Backup Time	The time range when the backup starts, for example, 05:00-06:00. Set this to your off-peak hours.
   Data Backup Frequency Settings	Specifies whether to enable the high-frequency backup and restoration feature. Important If you disable this feature, you cannot perform a point-in-time recovery. Proceed with caution.
   Data Backup Frequency	The time interval between the completion of one backup and the start of the next.

6. Click OK to save the backup settings.

Manual backup

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

2. In the left-side navigation pane, click Backup and Restoration.

3. On the Backup and Restoration page, click Create Backup.

4. In the dialog box that appears, click OK.

   After you click OK, the backup will start in 1 minute. If the amount of data is large, the backup job may take a long time. After the backup job is complete, refresh the current page to check its status.

Backup job list

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

2. In the left-side navigation pane, click Backup and Restoration.

3. Click the icon on the right to view the backup job list.

   The Backup Job List panel includes columns such as Backup Job ID, Backup Mode, Job Progress, Job Status, and Start Time.

Backup sets

A backup set is a full copy of your database. It is stored in Object Storage Service (OSS) and retained for 7 days by default.

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

2. In the left-side navigation pane, click Backup and Restoration.

3. On the Data Backup tab, view information about the base backup sets. The Consistency Point in Time is the latest point to which you can restore the instance with guaranteed data consistency.

   The backup list includes information such as Backup Start Time, Backup End Time, Backup Type, Backup Status, Backup Mode, and Backup Method. In the Actions column, you can click Restore To New Instance to restore the backup to a new instance.