Skip to main content

​
How backups work

DBHost uses pg_dump piped through gzip to create compressed SQL backups. Backups run asynchronously — you trigger them and they complete in the background. Each backup is stored on the VPS at /var/backups/postgresql/{database_name}/ as a timestamped .sql.gz file.

​
Triggering a backup

  1. Go to your database detail page
  2. Click the Backups tab
  3. Click Create Backup
The backup starts immediately and runs in the background. Refresh the page to see it appear in the list once complete.

​
Viewing backup history

The backups tab shows all available backups with:
  • Filename (timestamp-based: YYYYMMDD_HHMMSS.sql.gz)
  • Size (compressed)
  • Created at (UTC)

​
Restoring from a backup

Backup restoration is currently a manual VPS operation. Self-service restore is on the roadmap.
To restore a backup, SSH into the VPS and run: 
gunzip -c /var/backups/postgresql/mydb/20260319_120000.sql.gz | psql -U postgres mydb

​
Retention

Backups are retained for 7 days by default. Automated cleanup is planned but not yet active — backups currently accumulate until manually cleaned.