Restore a PostgreSQL Backup

A clear, step-by-step guide that details the process of restoring a PostgreSQL backup within your cluster. This overview focuses on executing the essential commands to recover your data, ensuring it is accurately reinstated and fully available—all without delving into advanced recovery configurations or long-term backup management tasks.

Here's the primary node—your central hub of operations.

Next, take a look at the backups inventory—your comprehensive list of all backups for this cluster and other PostgreSQL clusters.

Press the Backups layout to view more details.

Ready to restore a backup? Simply drag it from the backups inventory onto the primary node to start the restore process.

Choose one of the available restore options based on your needs.

You can also decide if the instance should start automatically after the restore.

Then, type "restore me" to confirm your intent and continue.

Instantly, a REST API command is generated—your key to automating future restore processes with your DEVOPS tool.

Once everything is set, press Submit to initiate the restore process.

You'll see a status update indicating that the restore process has started, followed by confirmation that the backup was restored successfully.