Updated on 2022-12-22 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.

    If the size of the backup data is greater than 400 MB, you are advised to use OBS Browser to download the backup data.

    • Use OBS Browser
      1. Download OBS Browser.
      2. Decompress and install OBS Browser.
      3. Log in to OBS Browser.
      4. Disable certificate verification on OBS Browser.

        The OBS bucket name displayed in the Download Backup File pane on the RDS console does not support certificate verification. Therefore, you need to disable OBS Browser certificate verification before adding the external bucket and then enable it after the backup file is downloaded.

      5. Add an external bucket.
      6. Download the backup file.

        On the OBS Browser page, click the bucket that has been successfully added. In the search box on the right of OBS Browser, enter the backup file name displayed on Download the Backup File of the RDS console. In the search result, locate the target backup and download it.

      7. After the backup file is downloaded, enable OBS Browser certificate verification.
    • 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.