Restoring a FlexusRDS for PostgreSQL Instance to a Point in Time

Scenarios

You can use automated backups to restore an instance to a specific point in time.

When you enter the time point that you want to restore the DB instance to, FlexusRDS downloads the most recent full backup file from OBS to the DB instance. Then, incremental backups are also restored to the specified point in time on the DB instance. Data is restored at an average speed of 40 MB/s.

Constraints

• Do not run the reset master command on instances within their lifecycle. Otherwise, an exception may occur during the point-in-time recovery (PITR).
• 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.
  • When you restore data to a new DB instance, large transactions in the original DB instance backup may cause a restoration failure. If the restoration fails, contact customer service.

Procedure

1. In the instance list, click the target instance name.
2. Click Backups and Restorations.
3. Click Restore above the backup list.
4. Select the restoration date and time range, enter a time point within the selected time range, and select a restoration method. Then, 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.