Help Center/ Relational Database Service/ User Guide/ Working with RDS for PostgreSQL/ Data Restorations/ Restoration Solutions

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

View PDF

Restoration Solutions

If your database is damaged or mistakenly deleted, you can restore it from backups.

Restoring a Mistakenly Deleted Instance

RDS moves unsubscribed yearly/monthly instances and deleted pay-per-use instances to the recycle bin. You can rebuild an instance that was deleted up to 7 days ago from the recycle bin.
You can restore a deleted instance from its retained manual backups. For details, see Restoring a DB Instance from Backups.

Restoring Mistakenly Deleted or Modified Data of a DB Instance

**Table 1** Restoration solutions
Solution	Category	Storage Type		Restoration Time Point	Scope		Restore To			Time Required
Solution	Category	Cloud SSD	Extreme SSD	Point in Time When a Backup Was Generated	All Databases and Tables	Certain Databases and Tables	New Instance	Original Instance	Existing Instance Other than the Original Instance	Time Required
Restoring an entire instance	Restoration from backups	√	√	x	√	x	√	x	√	Depending on how much data there is in the instance
Restoring an entire instance	Point-in-time recovery (PITR)	√	√	√	√	x	√	x	√	Depending on how much data there is in the instance
Restoring databases and tables	Restoration of databases and tables	√	√	√	x	√	x	√	x	Depending on how much data there is in the instance and in the databases and tables

Restoring or Migrating Data to an RDS for PostgreSQL Instance

You can restore data to an RDS for PostgreSQL instance from backups. For details, see Restoring Data to RDS for PostgreSQL.
You can migrate data to an RDS for PostgreSQL instance using Data Replication Service (DRS), pg_dump, or Data Admin Service (DAS). For details, see Migration Solution Overview.

Restoring or Migrating Data to a Self-Managed PostgreSQL Database

You can restore data to a self-managed PostgreSQL database from backups. For details, see Restoring Data to an On-Premises PostgreSQL Database from a Full Backup.
You can migrate data to a self-managed PostgreSQL database using DRS. For details, see From PostgreSQL to PostgreSQL.

Parent Topic: Data Restorations

Previous topic: Data Restorations

Next topic: Restoring Data to RDS for PostgreSQL

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.