Restore, download and import backups
Restore a snapshot or uploaded dump into a database, download .sql.gz exports and use command-line dumps.
Restore a snapshot
- Open Databases > Backups and find the snapshot under Saved Backup Snapshots Vault.
- Choose Restore to DB....
- Read the warning: the snapshot script runs against the database, recreating tables and restoring rows.
- Choose Proceed with Restore and watch the progress.
A restore needs a role that can write data (Owner, Admin or Developer). There is no automatic safety copy for this kind of restore, so choose Create Instant Backup first if the current data matters.
Upload a dump
Upload & Restore Dump... accepts .sql or .sql.gz. See Import data into a database.
Download
- Download next to a snapshot gives you that file.
- Download .sql.gz (top of the page) produces a fresh standalone export of the database for your machine. Manual exports are included at no extra fee.
Command line
The page shows ready commands under CLI Migration & Database Dump Commands: pg_dump to export and psql to restore, using the regular connection when available. See Connection strings.
History
Backup & Restore History shows each action (Vault Snapshot, Manual Backup, Restore), size and status.
Good to know
- Restoring into a database that is in use replaces data. Stop writers first.
- For restoring everything in a project at once, see Project recovery points.
More guides in Console: backups & recovery
Daily snapshots and retention
How automatic daily backups work, how to set retention, time and snapshot count, and when they cost money.
Project recovery points
Restore a whole project, all databases and stored files together, to an earlier point, and what happens to current data.
Hourly backups and point-in-time recovery
What the paid hourly backup option gives you, and what is and is not available for restoring to an exact moment.