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.
- If your RDS instance is equipped with standard or enhanced SSDs, you cannot download snapshot backup files.
- A RAM user with only read-only permissions cannot download data or log backup files. You can grant the required permissions to the RAM user in the RAM console. For more information, see Grant backup file download permissions to a RAM user with only read-only permissions.
- 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 the target RDS instance resides.
- Find the target instance and click the 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.
- Specify a time range.
- 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.
- 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 Endpoint Copy the internal endpoint that is used to download the backup file. If your ECS and RDS instances reside in the same region, you can log on to the ECS instance. Then, you can use the internal endpoint to download the backup file. This is the preferred method that is faster and more secure. Copy Public Endpoint Copy the public endpoint that is used to download the backup file. If you want to use other tools to download the backup file, copy the public endpoint.Note If you are using a Linux operating system, you can run the following command to download the backup file:
wget -c '<The endpoint from which you can download the backup file>' -O <The name of the backup file>
- The -c option enables resumable download.
- The -O option saves the downloaded backup file by using a specified name. We recommend that you use the file name contained in the endpoint.
- If the endpoint contains more than one parameter, enclose the endpoint in a pair of single quotation marks (').