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.
Hourly backups
On Databases > Backups you can tick Hourly backups: hourly snapshots instead of once a day. It is a paid add-on using the same size-based rate as going beyond the free daily allowance, and it requires a payment card on file (the page links to Billing if none). When on, the badge reads HOURLY ACTIVE.
Behind the scenes this option also keeps continuous change logs for the database. If the payment basis goes away, such as the card being removed, the option is suspended with a grace period, you are emailed, and it is then switched off. Nothing is deleted at once.
Point-in-time recovery
Restoring to an exact minute is not a button in the Console. Shared databases do not offer self-service point-in-time recovery; your options are:
- hourly or daily snapshots, restored per database,
- project recovery points. See Project recovery points.
If you run a dedicated deployment and need point-in-time recovery, ask support through your agreed terms.
Good to know
- Choose hourly backups only where losing a day would hurt.
- Test a restore on a separate database before you need it. See Restore, download and import backups.
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.
Project recovery points
Restore a whole project, all databases and stored files together, to an earlier point, and what happens to current data.