Project recovery points
Restore a whole project, all databases and stored files together, to an earlier point, and what happens to current data.
A project recovery point captures every database in the project and all of its stored files at one moment.
Availability
The Project recovery points card on Databases > Backups appears only when recovery points are switched on for the platform. If it is missing, recovery points are not switched on. The first point is taken at the next scheduled backup after they are.
What you see
A table of Taken, Type (Scheduled, Manual, Before a restore), and Contents (databases and files with sizes). A summary shows how long ago the last point was taken. Incomplete points say Incomplete and cannot be restored by you.
Restore a project
- Choose Restore on a point. Only the project's owners see the button.
- In Restore this project?, choose parts: Databases, Stored files and optionally Sign-in users, API keys and secrets.
- Type the project name exactly to confirm, then choose Restore.
The project goes back to that moment; later changes are replaced. The current state is saved first as a recovery point, so a restore can be undone, and files added since are kept aside for a limited time. While restoring, a banner says so. Restores are rate-limited per hour, and one runs at a time.
Good to know
- Owners only; Developers and Viewers cannot restore. See Invite teammates and choose roles.
- It also works from the mobile app. See The PGBHub mobile app.
- For one database use snapshots.
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.
Restore, download and import backups
Restore a snapshot or uploaded dump into a database, download .sql.gz exports and use command-line dumps.
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.