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
- Visit the RDS instance list, select a region above, and click the target instance ID.
- In the left-side navigation pane, click Backup and Restoration.
- 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.
- 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.
- 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.
- 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