You need to enable JavaScript to run this app.
RDS for PostgreSQL

RDS for PostgreSQL

  • Documentation
    • RDS for PostgreSQL User guideBackup recoveryData recoveryRestore to existing instance
Copy page
Download PDF
Data recovery
Restore to existing instance
Copy page
Download PDF
Restore to existing instance
This topic describes the procedure for restoring data to an existing instance. ​
Prerequisites​
  • A logical backup has been created for the data to be restored. For more information, see Creating a backup.​
  • Both the backup instance and the recovered target instance are in the Running state.​
Precautions​
  • Restoring a database to an existing instance through a logical backup is supported only.​
  • The compatible version of the target instance needs to be the same as the instance where the backup is located.​
  • Supports restoring the instance where the backup is located as the target instance.​
  • In a single recovery operation, only restoring data to one target instance is supported.​
Procedure​
  1. Login to the RDS for PostgreSQL console.​
  1. In the upper-left corner of the top menu bar, select the project and region for the instance.​
tip​
If the project of the instance has not been set, the project should be selected as All resources.​
  1. On the Instances page, click on the target instance name to enter the instance details page.​
  1. At the top of the page, click the Backups tab.​
  1. On the Backups tab, click Restore to existing instance under the Data backup tab.​
  1. On the Restore to existing instance page, click Next step after completing the following configuration.​
  • ​
    Parameters​
    Is it required?​
    Note​
    Restore method​
    ​
    Yes​
    Choose a recovery method Currently only restore By backup set is supported. The recovery method by backup set refers to restoring instances from a specified backup set, and the selection range of the backup set is determined according to the number of days the backup is retained.​
    Backup and recovery​
    Yes​
    Select the backup set to restore.​
    Target instance​
    Yes​
    Select the target instance for data recovery.​
    tip​
    • The compatible version of the target instance needs to be the same as the instance where the backup is located.​
    • Supports restoring the instance where the backup is located as the target instance.​
    • Only one target instance can be selected.​
    Target instance account​
    Yes​
    Select the account in the target instance to use as the owner of the newly restored database.​
    tip​
    Only super accounts that have not had their DDL permissions disabled are supported.​
    Database management​
    Yes​
    Select the database that needs to be restored from the backup set.​
    tip​
    You can choose up to 50 libraries for recovery at a time.​
    ​
​
  1. After confirming the selected data to be recovered and the restored database name, click OK.​
tip​
  • By default, the restored database is named according to [original library name] _bak_ [backup ID].​
  • Modifying the database name is supported. The following rules should be met when modifying. If not, the recovery task cannot be initiated.​
  • The name is unique within the instance.​
  • 2 to 63 characters in length.​
  • Must start with a letter and end with a letter or a digit.​
  • Can contain letters, digits, underscores (_) and hyphens (-).​
  • Some reserved words or keywords cannot be used in the database name, see Reserved keywords for all reserved keywords.​
Related APIs​
​
API​
Note​
RestoreToExistedInstance​
Call RestoreToExistedInstance API to restore data to an existing instance.​
​
​
​
​
Last updated: 2025.11.17 16:15:15