Updated on 2023-07-06 GMT+08:00

Downloading a Backup File

Scenarios

This section describes how to download a manual or an automated backup file to a local device and restore data from the backup file.

You can download both full and incremental backup files of PostgreSQL DB instances.

Downloading Full Backup

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service. The RDS console is displayed.
  4. On the Backup Management page, locate the target backup to be downloaded and click Download in the Operation column.

    Alternatively, click the target DB instance. In the navigation pane on the left, choose Backups & Restorations. On the Full Backups page, locate the target backup to be downloaded and click Download in the Operation column.

  5. In the displayed dialog box, select a method to download backup data.

    • Use Current Browser

      Download the backup file directly from the current browser.

    • Use Download URL

      Click to copy the URL within the validity period to download backup data.

      A valid URL for downloading the backup data is displayed.

      • You can use other download tools to download backup data.
      • You can also run the wget command to download backup data.

        wget -O FILE_NAME--no-check-certificate " DOWNLOAD_URL"

        Variables in the commands are described as follows:

        FILE_NAME: indicates the new backup file name after the download is successful. The original backup file name may be too long and exceed the maximum characters allowed by the client file system. You are advised to add -O in the wget command to rename the backup file name.

        DOWNLOAD_URL: indicates the path of the backup file to be downloaded.

  6. Restore data locally as required.

Downloading Incremental Backup

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service. The RDS console is displayed.
  4. On the Instance Management page, click the target DB instance. Choose Backups & Restorations in the navigation pane on the left. On the Incremental Backups page, locate the target backup to be downloaded and click Download in the Operation column.

    You can also select the incremental backups to be downloaded and click Download above the list.

  5. After the download is complete, you can view the incremental backups locally.