This topic describes how to download unencrypted data and log backup files from an ApsaraDB RDS for PostgreSQL instance. This allows you to manage the files by using an organized method. In addition, you can use the files to restore the data of the RDS instance to an on-premises database.

Limits

Procedure

  1. Go to the Backup and Restoration page.
    1. Log on to the ApsaraDB for RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where your RDS instance resides.
      选择地域
    2. Find your RDS instance and click its ID. In the left-side navigation pane, click Backup and Restoration.
  2. Click the Data Backup or Archived Logs tab.
    • If you want to download a data backup file, click the Data Backup tab.
    • If you want to download a log backup file, click the Archived Logs tab.
  3. Select a time range and click OK.
  4. Find the target data or log backup file and in the Actions column click Download.
    Note
    • If you want to download a data backup file that is used to restore data, we recommend that you select the file that was created at the closest point in time.
    • If you want to download a log backup file that is used to restore data to an on-premises database, make sure that the file meets the following requirements:
      • The Instance No. on the Archived Logs tab is the same as the Instance No. on the Data Backup tab.
      • The start time of the file is later than the start time of the specified time range. It must also be earlier than the point in time to which you want to restore data.
  5. In the Download Instance Backup Set message that appears, click Download.
    Download method Description
    Download Use a browser to download the backup file.
    Copy Internal URL Copy the internal URL from which you can download the backup file. If your ECS and RDS instances reside in the same region, you can log on to the ECS instance and then use the internal URL to download the backup file. This method is faster and more secure than the other download methods.
    Copy Public URL Copy the public URL to download the backup file. If you want to use other tools to download the backup file, select this download method.
    Note If you are using a Linux operating system, you can run the following command to download a backup file: 
    wget -c '<The URL from which you want to download the backup file>' -O <The name that you want to use for the downloaded backup file>
    • The -c parameter specifies to enable resumable download.
    • The -O parameter specifies to save the downloaded backup file by using a specified name. We recommend that you use the original file name that is provided in the specified URL.
    • If the specified URL contains more than one parameter, we recommend that you enclose the URL in a pair of single quotation marks ('). This prevents download failures.
    Download a data backup file