This topic describes how to download the unencrypted data backup files and log backup files of an ApsaraDB RDS for PostgreSQL instance. You can archive the backup files that you download. You can also use the backup files that you download to restore the data of the RDS instance to an on-premises database.

Precautions

  • If your RDS instance uses standard SSDs or enhanced SSDs (ESSDs), you cannot download the snapshot backup files of the instance.
  • A RAM user that has only the read permissions on your RDS instance is not authorized to download the backup files of the instance. You can grant the required permissions to a RAM user in the Resource Access Management (RAM) console.

Procedure

  1. Visit the RDS instance list, select a region above, and click the target instance ID.
  2. In the left-side navigation pane, click Backup and Restoration.
  3. 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.
  4. Change the default time range. This step is required if you want to view the backup files that are generated eight days ago. The default time range spans the most recent eight days.
  5. Find the data backup file or log backup file that you want to download. Then, click Download in the Actions column.
    Note
    • If the Download button cannot be found, you must check the storage type of the RDS instance. Snapshot backup files cannot be downloaded for RDS instances that use standard SSDs or ESSDs
    • If you want to download a data backup file and use it to restore data, we recommend that you select the data backup file that is generated at the point in time closest to the point in time to which you want to restore data.
    • If you want to download an archived log backup file and use it to restore data to an on-premises database, you must take note of the following information:
      • The instance No. of the log backup file must be the same as the instance No. of the data backup file that is used together with the log backup file to restore data.
      • The start time of the log backup file must be later than the end time of the data backup file that is used together with the log backup file to restore data. The start time of the log backup file must also be earlier than the point in time to which you want to restore data.
  6. In the dialog box that appears, copy the URL from which you can download the backup file.
    • Copy Internal URL: You can log on to your Elastic Compute Service (ECS) instance and use the internal URL to download the backup file. This method is faster and more secure. It is suitable if your ECS instance resides in a virtual private cloud (VPC) and connects to your RDS instance over an internal network.
    • Copy Public URL: You can use the public URL to download the backup file. This method is suitable if your RDS instance cannot be connected over an internal network