For the complete documentation index, see llms.txt. This page is also available as Markdown.
Restore a PostgreSQL Cluster
With IONOS CLOUD DBaaS, you can roll back a PostgreSQL cluster to a previous point in time using point-in-time recovery (PITR). This prevents data loss in unexpected situations such as accidental data deletion.
Note: You can restore only one backup at a time. You must wait for the current restoration to complete before initiating another.
Prerequisites:
The backup must belong to the PostgreSQL cluster to be restored.
The backup must be active. Inactive backups are not eligible for restoration.
The cluster must be in the AVAILABLE state.
To restore a cluster from a backup, follow these steps:
1
Navigate to the cluster
1. In the DCD, go to Menu > Databases > PostgreSQL.
A list of all PostgreSQL clusters is displayed.
2. Select a cluster from the list by clicking on its name. Alternatively, click Details in the OPTIONS column.
Select a PostgreSQL cluster
2
Open the Backups tab
In the cluster details page, select Backups.
The Point-in-time recovery section displays the earliest backup available for restoration.
Point-in-time recovery
2. Select Restore backup to open the restore dialog.
3
Set the recovery target time
In the Restore backup dialog, the Earliest recovery target time is displayed. Each backup has a recovery window defined by an earliest and a latest recovery target time. You can restore the backup to any point within this range.
1. Click the date and time field and enter a recovery target time. Select a date and time from the calendar. Only dates within the available backup window are selectable.
Note: The backup is replayed up to the specified timestamp. If left empty, the latest available backup is applied completely.
Select recovery date and time
2. Select Restore to start the restoration.
Result: The cluster's STATE is set to UPDATING while the restoration is in progress. Once complete, the cluster returns to AVAILABLE.
