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.
   Figure 1 Selecting a download method
   
   • Use OBS Browser

     OBS outbound public traffic is free of charge for using OBS Browser to download backup data.

     Figure 2 Using OBS Browser to download backup data
     
     1. Download OBS Browser following the instructions provided in Figure 2.
     2. Decompress and install OBS Browser.
     3. Log in to OBS Browser.

        For details about how to log in to OBS Browser, see the Logging In to OBS Browser section in the Object Storage Service User Guide.

     4. Disable certificate verification on OBS Browser.

        For details on how to configure OBS Browser, see section Configuring the System in the Object Storage Service Tools Guide.

        

        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.

        In the Create Bucket dialog box of OBS Browser, select Add external bucket and enter the bucket name displayed in step 2 of Figure 2.

        For details about how to add external buckets, see the Adding External Buckets section in the Object Storage Service User Guide.

     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 step 3 of Figure 2. 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 such as browsers or Thunder 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. For details, see Restoring from Backup Files to a Self-Built PostgreSQL Database.

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.