Restore a PostgreSQL Cluster
With IONOS CLOUD DBaaS, you may roll back your PostgreSQL clusters to a previous point in time or use it to create a new cluster. This reliable function prevents data loss and downtime in unexpected situations.
For example, consider that certain values were accidentally deleted from your cluster around 11 hours today. The easiest way to recover missing data is to restore a backup before 11 hours.
Restore a Cluster
To restore a cluster, follow these steps:
1. In the DCD, go to Menu > Databases > PostgreSQL.
2. Select a cluster from the list by clicking on its name. Alternatively, click Details in the OPTIONS column.

3. The Cluster details tab displays the necessary information of the chosen cluster. For more information, see View PostgreSQL Cluster Details.
4. Select Backups and Cluster Restore to view the list of backups. Point-in-time recovery displays the earliest backup available for restoration. Select Restore backup for backup restoration.

a. In the Restore backup pop-up window, click within the text box to open the Calendar.
b. Select date and time. Backups are available only for those dates that are available for selection.
c. Select Restore to proceed with the restoration.

Last updated
Was this helpful?