Docs

RDS for PostgreSQL

Data backup

Creating a data backup

This topic describes how to create a data backup.

Prerequisites

An instance is created and in the Running state. For more details, refer to Creating an instance.

Precautions

Backups are retained for 7 to 365 days, after which they will be deleted. If you need to keep backups for a long time, you can download them locally. For more details about downloading backups, see Downloading data backup files.

Procedure

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.

Click on Instances in the left navigation bar.

On the Instances page, click on the target instance name to enter the instance details page.

At the top of the page, click the Backups tab.

Under the Data backup page, click Manual backup.

On the pop-up Manual backup page, after completing the following settings, click OK.

Configuration item	Required?	Description
Backup object	Yes	Set the backup target. You can select Entire instance or Specified databases.
Backup type	Yes	Set the backup type. You can choose Physical or Logical. tip When you select the backup target as the Specified databases, the backup type can only be selected as Logical. If the instance does not have a database, creating a logical backup is not supported.
Database	Yes	Select the database that needs to be backed up. tip Settings are supported only when the backup target is selected as the Specified databases. You can choose up to 2000 databases. A single backup can support up to 50,000 tables (the sum of all tables in the selected database). Backing up databases with more than 1000 tables is not supported yet.
Backup set description	No	Add a description of the backup set for subsequent management of backups. Supports up to 256 characters.

Next steps

Viewing data backup progress

After the backup is created, refresh the backup list to view the newly created backup. In the Status column of the Backup list, the status of the backup is displayed. If a backup is in progress, the Status column shows In progress and the backup progress as a percentage.

tip

You need to manually refresh the list to view the latest backup progress.

Viewing backup

In the backup list of the Backups page, the backup ID, backup status, backup method, backup size, start time and end time of the backup are displayed. Backups can be filtered through Method.

In the backup list, click Restore in the Actions column of the backup list to restore from the corresponding backup. For more information about recovery, see Restoring to a new instance.

Related APIs

API	Note
CreateBackup	Call the CreateBackup API to create a data backup.

Last updated: 2026.04.22 21:12:00