Restore a PostgreSQL Cluster

With IONOS 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.

Note: You can restore only one backup at a time, and you must wait for the restoration process to finish before restoring another backup.

Prerequisites:

• The backup must belong to the PostgreSQL cluster to be restored.

• The cluster must be in the AVAILABLE state.

Restore a Cluster

To restore a cluster, follow these steps:

1. Log in to the DCD with your username and password.

2. Go to Menu > Databases > PostgreSQL.

Select PostgreSQL from the menu

1. Select a cluster from the list by clicking on its name. Alternatively, click Details in the OPTIONS column.

Select a PostgreSQL cluster

1. The Cluster details tab displays the necessary information of the chosen cluster. For more information, see View PostgreSQL Cluster Details.

2. Select Backups to view the list of backups. Point In Time Recovery displays the earliest backup available for restoration. Select Restore backup for backup restoration.

   

   Point in time recovery option

   a. In the Restore backup pop-up window, click within the text box to open the Calendar.

   

   Select a date and time to restore

   b. Backups are available only for those dates that are available for selection. Select a date and click Ok.

   

   Select a date

   c. Select the Clock icon to set a time for restoring the appropriate backup from the chosen day. Click Ok to confirm your selection.

   

   Select a backup time

   d. Select Restore to proceed with the restoration.

   

   Restore the chosen backup

   e. Select Restore to confirm the restoration.

   

   Confirm restoration

Result: You will receive a confirmation that the cluster will be restored, and the respective cluster's STATE is set to Busy.

Restoration is in progress