tencent cloud

All product documents
TencentDB for PostgreSQL
DocumentationTencentDB for PostgreSQLOperation Guide Backup and RestorationRollback to the Original Instance
Rollback to the Original Instance
Download PDF
Last updated: 2024-08-09 15:15:34
Rollback to the Original Instance
Last updated: 2024-08-09 15:15:34
Download PDF
Note:
Rollback to the original instance supports the operation of database-level objects.
For instances of SQL Server compatible engines, the rollback of mssql_compatible databases is currently not supported.
Up to 100 databases can be selected for a single rollback task.
Rollback to the original instance allows you to restore existing database objects in the current instance to a specific point in time or backup set. It can also solve the problem of recovering accidentally deleted databases. A detailed description is provided below.

Selecting the Recovery Method and Time Point

Note:
The selectable time for database table recovery is strongly related to your current backup retention policy. For backup settings, refer to Instructions.
You can choose to recover to a specific backup set or to any point in time when the system detects data.


Selecting the Database to Recover

You can select an existing database pulled by the current system for recovery. Details are shown in the figure below:


Name after Recovery

The name of the recovered database will have a *_bak_timestamp suffix. The timestamp is a Unix timestamp when a backend task is initiated. After you submit a database table rollback task on the console or via API, the backend will initiate a rollback task within 5 minutes. For example, if the database name selected by you is dbone and the backend initiates the task at 2024-05-30 11:26:25, the new database name after the recovery task is completed will be dbone_bak_1717039585.

Handling Accidental Database Deletion

If a database is deleted due to misoperation, the database table rollback feature can resolve this problem. Since the deleted database cannot be retrieved when a task is initiated, you can start the task by adding a new database. Click Add in the figure below.

Note:
If the added database name does not exist in the selected backup set or PITR time point, an empty database will be recovered.


Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon