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

Precautions

  • If your RDS instance uses standard or enhanced SSDs, you cannot download snapshot backup files from the instance.
  • A Resource Access Management (RAM) user that has only the read permissions on your RDS instance is not authorized to download backup files from the instance. You can grant the required permissions to the RAM user by using the 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 Log Backup 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 last eight days.
  5. Find the data or log backup file that you want to download. Then, click Download in the Actions column.
    Note
    • 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 closest point in time.
    • If you want to download an archived log backup file and use it to restore data to an on-premises database, take note of the following items:
      • The instance No. of the log backup file must be the same as that of the data backup file that is used with the log backup file.
      • The start time of the log backup file must be later than the end time of the data backup file and earlier than the specified point in time.
  6. In dialog box that appears, copy the URL from which you want to download the backup file.
    • : 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.
    • : 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