Updated on 2025-01-26 GMT+08:00

Restoring a FlexusRDS for PostgreSQL Instance from Backups

Scenarios

This section describes how to use an automated or manual backup to restore a DB instance to the status when the backup was created. The restoration is at the DB instance level.

When you restore a DB instance from a backup, the backup is downloaded from OBS and then restored to the DB instance at an average speed of 40 MB/s.

Constraints

  • Constraints on restoring data to a new DB instance:
    • You can restore data to a new instance only when your account balance is greater than or equal to $0 USD. You will pay for the new instance specifications.
    • The storage space of the new instance should be no less than that of the original instance.
    • If transparent page compression is enabled by specifying attributes in the CREATE TABLE statement for the original DB instance, the restoration may fail due to insufficient storage space.

Procedure

  1. In the instance list, click the target instance name.
  2. Click Backups and Restorations.
  3. Locate the backup to be restored and click Restore in the Operation column.
  4. Select a restoration method and click OK.

    • Create New Instance

      The Create New Instance page is displayed.

      • The DB engine version of the new instance is the same as that of the original instance.
      • You can select a new instance class for the new instance, but the storage of the new instance must be no less than that of the original instance.
      • For details about the configuration items on the purchase page, see Buying a FlexusRDS for PostgreSQL Instance.

      To change the instance class, choose a new one for the new instance on the Create New Instance page.

  5. View the restoration result. The result depends on which restoration method was selected:

    • Create New Instance

      A new DB instance is created using the backup data. The instance status changes from Creating to Available.

      The new DB instance is independent from the original one. After the new instance is created, a full backup will be automatically triggered.