Glossary
Concepts
Initial Setup
Peformance & Benchmark
Troubleshooting
FAQs
The Restore and Point-in-Time Recovery (PITR) features allow users to recover a database from existing backups or restore a database to a specific point in time in the past. This section provides detailed instructions to help users perform data recovery accurately, safely, and efficiently, while ensuring data integrity.
When performing Restore or PITR, the system will create a new database cluster and will not overwrite the existing cluster.
Currently, FPT Cloud supports Restore for all available database engines and supports PITR for PostgreSQL.
The Restore feature allows users to use a previously created backup to recover data and create a new database cluster. This is useful in cases of data loss, system failures, or when a rollback to a previous state is required.
Before performing a restore, ensure the database cluster has at least one successfully created backup (restore point) - meaning at least one restore point is available.
Steps to perform restore:
From the menu, select Database Platform → choose All Database or the relevant database group → click the Cluster ID of the database cluster to restore → select the Backup tab → choose the Restore sub-tab. The system displays a list of Available Restore Points, including backup types (Full or Diff):

In the Actions column, click the ellipsis icon (⋮) corresponding to the desired restore point > select Restore. The Restore Database dialog appears:

Enter the required information:
Click Restore to start the recovery process. Upon successful restore, a new database cluster will appear in the Database Engines list containing data from the selected backup.
The Recover to Point-in-Time feature allows users to restore a database to an exact point in the past, which is especially useful when recovering from incidents or operational errors.
Currently, this feature is supported only for PostgreSQL.
Before performing PITR, ensure that:
Steps to Perform Recover to Point-in-Time:
Follow the same steps as accessing the Restore screen in the Restore Database section.
On the Restore tab, click the Restore to point in time button > The Restore Database to a Point in Time popup appears:

Enter the required information:
Click Recover to start the recovery process. The system will create a new cluster and restore data to the specified point in time. Upon successful recovery, a new cluster will appear in the Database Engines list screen containing data at the recovery time.
Note: You can only recover data to points in time after the first Full Backup has been created since PITR was enabled. If this Full Backup has not yet been executed, the PITR feature will not be available. Any data changes that occurred before this Full Backup point are not protected by PITR and cannot be recovered.