All Products
Search
Document Center

AnalyticDB:Back up data

Last Updated:Jul 08, 2024

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

View and modify backup policies

  1. Log on to the AnalyticDB for PostgreSQL console.
  2. In the upper-left corner of the console, select a region.
  3. Find the instance that you want to manage and click the instance ID.
  4. In the left-side navigation pane, click Backup and Restoration.

  5. On the Backup and Restoration page, click the Backup Settings tab to view backup settings.

  6. To modify the backup settings, click Modify Backup Settings.

  7. In the Backup Settings panel, configure the parameters based on the instance version.

    • The following table describes the parameters for an AnalyticDB for PostgreSQL instance that supports physical backup.

      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 select an off-peak hour.

      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

      Important

      The 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 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 an AnalyticDB for PostgreSQL instance that supports snapshot backup.

      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 select an off-peak hour.

      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

  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 a region.
  3. Find the instance that you want to manage and click the instance ID.
  4. In the left-side navigation pane, click Backup and Restoration.

  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.

    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

Important

You can view the restore points in time of only AnalyticDB for PostgreSQL instances that support physical backup.

  1. Log on to the AnalyticDB for PostgreSQL console.
  2. In the upper-left corner of the console, select a region.
  3. Find the instance that you want to manage and click the instance ID.
  4. In the left-side navigation pane, click Backup and Restoration.

  5. On the Backup and Restoration page, click the Restore Points tab.

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

    Important

    The 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 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

  1. Log on to the AnalyticDB for PostgreSQL console.
  2. In the upper-left corner of the console, select a region.
  3. Find the instance that you want to manage and click the instance ID.
  4. In the left-side navigation pane, click Backup and Restoration.

  5. On the Backup and Restoration page, click the Log Backup tab.

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