This document describes how to modify the automatic backup settings in the TencentDB for PostgreSQL console. TencentDB for PostgreSQL will automatically back up data based on the default or configured backup settings.
Notes
Back up your data during off-peak hours.
Backup may take a long time if the data volume is large.
The backup mode is physical backup, while logical backup is not supported currently.
Directions
2. On the instance management page, select the Backup and Restoration tab and click Auto-Backup Settings.
3. In the Backup Settings pop-up window, complete the data backup settings and click OK.
Backup Start Time: You can select the default time (i.e., when the resources are idle) or specify a time. Backups are initiated within this time window. If a backup fails to start as configured, it will not be retried, and another backup will be initiated in the next time window.
Data Backup Retention Period: You can specify a time range of 3–7 days after which the backup set will be automatically deleted. Data can only be restored to a specific point in time within the retention period.
Backup Cycle: Any day between Monday and Sunday can be selected.
4. When "Configured backup settings successfully" is displayed in the top-right corner, the automatic backup settings are completed.
Description of Automatic Backup Settings
|
Backup Start Time | The default time is the moment when an automatic backup is initiated. You can customize this parameter. It is recommended that you set the backup start up when the traffic is low. The backup initiation time only indicates when the backup procedure starts, but does not represent the end time. For example, if you decide to start a backup task between 02:00~06:00, the backup task will be triggered at a certain point within the 02:00~06:00 interval, depending on the backup policy at the backend and the conditions of the backup system. |
Data Backup Retention Time | Range: 7 to 1,830 days, default: 7 days. Expired backup sets will be automatically deleted. |
Backup Schedule | Monday to Sunday (7 days) are selected by default. You can also custom the specific days. However, to ensure your data's security, please set to back up data at least twice a week. |
Was this page helpful?