# Restore a PostgreSQL Cluster

With <code class="expression">space.vars.ionos\_cloud</code> 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.

{% hint style="info" %}
**Note:** You can restore only one backup at a time, and you must wait for the restoration process to finish before restoring another backup.
{% endhint %}

{% hint style="info" %}
**Prerequisites:**

* The backup must belong to the PostgreSQL cluster to be restored.
* The cluster must be in the **AVAILABLE** state.
  {% endhint %}

## 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.

![Select a PostgreSQL cluster](/files/cO6E2sVZJCjpVbGXxUZp)

3\. The **Cluster details** tab displays the necessary information of the chosen cluster. For more information, see [<mark style="color:blue;">View PostgreSQL Cluster Details</mark>](/cloud/databases/postgresql/how-tos/view-cluster-details.md).

4\. 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](/files/n4j0tckOWnleJLWOOflF)

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.

![Restore the chosen backup](/files/jfqmqVtBgkfgF1x4RDbk)

{% hint style="success" %}
**Result:** You will receive a confirmation that the cluster will be restored, and the respective cluster's **STATE** is set to **Busy**.
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.ionos.com/cloud/databases/postgresql/how-tos/restore-from-backup.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.