This topic describes how to view backup data and modify backup settings in AnalyticDB for PostgreSQL.

View and modify backup polices

  1. Log on to the AnalyticDB for PostgreSQL console.
  2. In the upper-left corner of the console, select the region where the instance resides.
  3. Find the instance that you want to manage and click its ID.
  4. In the left-side navigation pane, click Backup recovery.
  5. On the page that appears, click the Backup settings tab to view backup settings.
  6. To modify the backup settings, click Modify backup configuration.
  7. In the Backup configuration panel, set the following parameters.
    Parameter Description
    Data backup retention days The retention period of data backups. Valid values: 1 to 7. Unit: days.

    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 start 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.
    Recovery point settings Specifies whether to enabled point-in-time restoration.

    If this feature is disabled, data cannot be restored by point in time.

    Recovery point frequency The frequency at which you want to perform point-in-time restoration. Valid values:
    • Hourly
    • Every two hours
    • Every four hours
    • Every eight hours
  8. Click OK.

View base backup sets

  1. Log on to the AnalyticDB for PostgreSQL console.
  2. In the upper-left corner of the console, select the region where the instance resides.
  3. Find the instance that you want to manage and click its ID.
  4. In the left-side navigation pane, click Backup recovery.
  5. 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.

    Information of base backup sets is displayed on this tab, as shown in the preceding figure. The information includes 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 restoration points in time

  1. Log on to the AnalyticDB for PostgreSQL console.
  2. In the upper-left corner of the console, select the region where the instance resides.
  3. Find the instance that you want to manage and click its ID.
  4. In the left-side navigation pane, click Backup recovery.
  5. On the page that appears, click the Recovery point tab.
  6. View restoration points in time on the Recovery point tab.
    A restoration point in time indicates the point in time to which you can restore instance data.

    The name and timestamp of each restoration point in time are displayed on this tab, as shown in the preceding figure. You can restore instance data to a restoration point in time.

View log backups

  1. Log on to the AnalyticDB for PostgreSQL console.
  2. In the upper-left corner of the console, select the region where the instance resides.
  3. Find the instance that you want to manage and click its ID.
  4. In the left-side navigation pane, click Backup recovery.
  5. On the page that appears, click the Log backup tab.
  6. View log backups on the Log backup tab.
    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.