This topic describes how to restore backup data to a new instance in AnalyticDB for PostgreSQL.

Precautions

  • Both the source and destination instances must be in elastic storage mode.
  • The source and destination instances must reside within the same region.
  • The storage capacity of the destination instance must be greater than or equal to that of the source instance.
  • The amount of time consumed by instance data restoration is determined by the volume of data stored in the source instance. Typically, the data of an instance is restored within a few hours.

Procedure

  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. Click the Data backup or Recovery point tab. Find a backup that you want to use to restore data and click Recovery in the Actions column.
  6. On the Clone Instance page, configure the parameters described in the following table.
    Parameter Description
    Source Instance The source instance whose data you want to restore.
    Restore Mode The mode that is used to restore data. It is automatically set to Backup Set.
    Backup Set The point in time to which you want to restore data.
    Region The region in which to clone the instance. It is automatically set to the region in which the source instance resides.
    Zone The zone in which to clone the instance.
    Network Type The network type of the destination instance. It is automatically set to VPC.
    VPC The ID of the virtual private cloud (VPC).
    VSwitch The vSwitch in the specified VPC.
    Instance Resource Type The resource type of the destination instance. It is automatically set to Elastic Storage Mode.
    Edition The edition of the destination instance. Set the edition to High Performance (Basic Edition) or High-availability based on your business requirements.

    Basic Edition is available only in some regions and zones. For more information about the specific regions and zones, see Scope.

    For more information about Basic Edition, see Basic Edition.

    Compute Node Specifications The specifications of compute nodes in the destination instance.
    Nodes The number of compute nodes in the destination instance.
    Single Node Storage Capacity The storage capacity per compute node in the destination instance. The total storage capacity of compute nodes in the destination instance must be greater than or equal to that in the source instance.
    Storage Disk Type The disk type. Valid values:
    • Enhanced SSD (ESSD)
    • Ultra Disk
    Note Only Enhanced SSD (ESSD) is available if you set the edition to Basic Edition.
    Encryption Type The encryption type.

    If you set the encryption type to Disk Encryption, you must also specify CMK.

  7. Read and select Terms of Service.
  8. Click Buy Now.
    Note A new instance is created with the data of the source instance restored. The amount of time consumed by instance data restoration is determined by the volume of data stored in the source instance. Typically, the data of an instance is restored within a few hours.