This document describes the operation of instance and method for restoring a backup file to a new TencentDB for PostgreSQL instance.
Applicable Scope
Database instances of major version 11 or higher.
Note:
Note: The TencentDB for PostgreSQL instance restored from a backup file has the same major version as the source instance, and the latest kernel minor version will be used.
Concept Introduction
A backup set refers to a collection of files generated during the database backup process, including data backup files and log backup files. The backup set files serve as the basic data source for database recovery.
The data backup file includes three types: automatic, manual, and final. Details are as follows:
Type
Source
Retention policy
Space Usage Cost
Recovery Operations
Delete Operation
auto
Automatically generated by the system.
By default, backups are retained for 7 days from the generation time. Users can also customize the setting. For details, please refer to Automatic Backup Settings.
Consistent with the instance running pricing. For details, please refer to Backup Space Billing.
Recover by backup set or time point recovery.
If a backup set contains data within 2 days, it cannot be deleted.
Manual
Users can save by themselves. For details, please refer to Data Backup.
Permanent retention.
Consistent with the instance running pricing. For details, please refer to Backup Space Billing.
Recover by backup set or time point recovery.
Self-service deletion.
Final
The instance is automatically generated by the system when it is put into the recycle bin and completely cleared upon expiration.
Retention period: 8 days from generation time.
No charge.
Recover by backup set or time point recovery.
Non-deletable, can only be automatically cleared by the system upon expiration.
Feature Introduction
Querying a Backup Set
After the instance is decommissioned from the recycle bin, you can view its data backup and log backup files on the Backups of Terminated Instances webpage. The system supports filtering specific backup sets by file creation time, instance ID, instance name, or instance IP. Log in to the TencentDB for PostgreSQL console > Database Backup page, select Backup List > Backups of Terminated Instances. The system supports quick filtering for today, yesterday, or the last 7 days. You can also customize the start and end time in the time filter box at the top right of the list to filter by "task start/end time."
Restoring a Deleted Instance
Note:
Note: When TDE is enabled for your instance, please ensure the KMS key is in normal usage status. Otherwise, keys cannot be obtained from KMS, which will cause the recovery feature to fail.
2. Select database parameters, then click Purchase Now to pay.
Recovery method
By time point: Restore by specifying a time point within the traceable time range of the backup file.
Note:
Note: The recoverable time point when selecting point-in-time recovery depends on the log backup files you reserved. After deletion of log backup files, the time points afterward cannot be recovered.
By backup set: Select the time node when the backup file was generated to restore.
Note:
Recovered instances:
- The major kernel version matches the original instance, and the latest minor kernel version will be used.
Instance location, userName, user password match the source instance.
After instance recovery, the backup file of the terminated instance still exists.
Download Backup File Manual Self-Build Restore
If you wish to migrate data to a Cloud Virtual Machine (CVM), the system supports downloading backup files of terminated instances for users to manually rebuild the database locally.
2. For the required backup file, click Download in the Operation column to perform manual data recovery. For details, please refer to Restore PostgreSQL Data on CVM.
Deleting Backup Files
For instances decommissioned from the recycle bin, if their backup sets still exist, you can delete these backup sets if they are no longer needed. Log in to the TencentDB for PostgreSQL console > Database Backup page, select Backup List > Backups of Terminated Instances, then choose the backup files to delete. If no deletion is required, the backup sets will be automatically deleted by the system upon expiry.
Note:
To ensure the recovery duration of your terminated instance, the system will initiate a final backup and generate a final backup set when the instance goes offline in the Recycle Bin. The final backup set will be retained for 8 days with no charge and is non-deletable.
To ensure data recoverability, backup sets generated within two days are currently undeletable.
