Backups
Every PostgreSQL database is backed up automatically. You can also trigger a backup yourself before risky changes, or restore the whole database from any completed snapshot.
Automatic schedule
Section titled “Automatic schedule”| Type | When |
|---|---|
| Daily | Once a day. |
| Weekly | Once a week. |
Backups are full-database snapshots. They run in the background and don’t interrupt your queries.
On-demand backup
Section titled “On-demand backup”Open the Backups tab and click Backup now. Useful before a schema migration, a big delete, or any change you might want to undo.
Restore
Section titled “Restore”From the Backups tab, click Restore on any completed backup. The database is rolled back to that snapshot — current data is replaced.
Two things to keep in mind:
- The database must be running to restore.
- Restore replaces the entire database state — there is no point-in-time / partial restore. If you only need a few rows back, restore into a fresh database instead and copy the rows over.
Retention and platform reference
Section titled “Retention and platform reference”For the full backup retention policy and a cross-service overview see Backups.