Restores for PostgreSQL

You can use the ScaleGrid restore UI to restore data on your PostgreSQL instance from a selected backup.

šŸš§

  • Restoring a backup removes all the existing data in the current deployment and replaces with data in the backup.

  • Restore process is agnostic of the amount of data. It takes a fixed amount of time irrespective of the size of the data being restored.

To use the restore backup functionality, please follow these steps:

Step 1: Visit the overview page of the PostgreSQL deployment, click on the Backup & Restore menu option and choose Restore:

192

Step 2: Select the PostgreSQL backup from the Backup List that will be used to restore the data on the deployment. If a comment was added during the on-demand backup creation process, it will show up here.

šŸ“˜

The Taken on property in the restore UI provides the exact time of the snapshot in your local time ā€“ this is the time we issued a snapshot command on the server.

597

Step 2: Select a backup from the Backup List to restore

Once you've selected the backup, click on the "Restore" button to start the restore job.