TencentDB for PostgreSQL
- Release Notes and Announcements
- Announcements
- Product Introduction
- Purchase Guide
- Getting Started
- Kernel Version Introduction
- Operation Guide
- Instance Management
- Upgrading Instance
- Read-Only Instance
- Account Management
- Database Management
- Database Optimization
- Parameter Management
- Log Management and Analysis
- Backup and Restoration
- Data Migration
- DTS-Based Logical Migration
- Verification Failure Handling
- Physical migration based on DTS
- Database Audit
- Extension Management
- Supported Extensions
- Network Management
- Data Security
- Tenant and Resource Isolation
- Monitoring and Alarms
- MSSQL Compatible Version
- Practical Tutorial
- Performance White Paper
- API Documentation
- Making API Requests
- Instance APIs
- Read-only Replica APIs
- Backup and Recovery APIs
- Parameter Management APIs
- Security Group APIs
- Performance Optimization APIs
- Specification APIs
- PostgreSQL for Serverless APIs
- Network APIs
- Service Agreement
Backing up Data
Last updated: 2024-04-09 10:47:26
This document describes how to set backup parameters and download backup files via the TencentDB for PostgreSQL console.
Operation Scenarios
Currently, TencentDB for PostgreSQL High Availability Edition only supports physical backup:
Full backup: once a day at 01:00.
Incremental backup: for xlog files, backup will be performed once every 15 minutes or when the number of files reaches 60.
Data file retention period:Range: 7 to 1830 days.
Manual Backup: If you initiate a backup task manually, the task will start within one minute after you click OK.
Directions
1. Log in to the TencentDB for PostgreSQL Console and click an instance ID to enter the instance details page.
2. On the Backup Management tab, click Date Backup List or Log Backup List, select the desired backup, and click Download in the "Operation" column.
Note:
Backup data in the Date Backup List is full backup, while that in the Log Backup List is incremental backup.
3. In the pop-up window, you can choose a VPC address or public network address to download the backup file.
Note:
To ensure data security, an address will be valid for 12 hours. After it expires, please refresh the page to get a new address. Please access a VPC address in a VPC.
4. You can initiate backup tasks as needed. On the Backup and Restoration tab, click Manual Backup to start a manual backup task.
Note:
You can not initiate a manual backup during the execution of the routine auto backup tasks.
You can delete manual backups in the backup list to free up backup space, avoiding space waste and occupation. Otherwise, these manual backups will be retained until the database instance goes offline.
5. In the Manual Backup dialog, click OK.
Note:
The creation time of a manual backup relates to the actual capacity of the instance. Larger capacity results in longer creation time.
FAQs
Can backups exceeding the retention period still be downloaded or restored?
Expired automatic backup sets will be automatically deleted and cannot be downloaded or restored. You can manually backup instance data in the console, and manual backups are always saved.
Can backups be manually deleted?
Automatic backups within 7 days cannot be deleted. Those beyond 7 days can be deleted as needed, and the system will also delete automatic backups based on their corresponding retention durations. Manual backups can be manually deleted from the backup list; otherwise, they will be retained permanently.
Can data and log backups be disabled?
No, they cannot be disabled. However, you can lower the backup frequency and delete unnecessary to reduce the backup space usage.
How can I reduce backup space overhead?
Delete unnecessary manual backup data.
Lower the automatic backup frequency for non-core service data (at least twice a week).
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No