Database Backups
Automatic daily backups for PostgreSQL databases with 30-day retention.
Every PostgreSQL database on SMLL is automatically backed up once per day. Backups are stored separately from your database and retained for 30 days.
How it works
- Schedule: Daily at 03:00 UTC
- Retention: 30 days (oldest backups pruned automatically)
- Type: Physical base backup via
pg_basebackup - Storage: Backups are stored on separate infrastructure from your database
Viewing backups
Navigate to your database's Backups tab to see:
- List of available backups with timestamps and sizes
- Backup status (completed, in progress, failed)
- Retention remaining for each backup
Restoring from a backup
- Navigate to your database's Backups tab
- Click Restore next to the desired backup
- Confirm the restore operation
The database will be temporarily unavailable during restore. Typical restore times:
| Database size | Approximate time |
|---|---|
| < 1 GB | 1–2 minutes |
| 1–10 GB | 5–15 minutes |
| 10–50 GB | 15–45 minutes |
Manual backups
You can trigger a manual backup at any time from the Backups tab. Manual backups count toward the same 30-day retention window.
Backup storage pricing
Backup storage is included free for all databases. There is no additional charge for backup storage.