SMLL Docs

Database Backups

Automatic daily backups and manual snapshots for your PostgreSQL databases.

SMLL automatically backs up your databases daily. You can also create manual snapshots at any time.

Automatic backups

Every database is backed up on a schedule:

  • Frequency: Daily at 02:00 UTC
  • Retention: 30 days
  • Method: Physical base backups via CloudNativePG + continuous WAL archiving

Automatic backups happen in the background with no impact on database performance.

Manual snapshots

You can create a point-in-time snapshot of any running database:

  1. Go to your database detail page
  2. Click Create Snapshot
  3. The snapshot is created using Kubernetes VolumeSnapshots

Manual snapshots are stored alongside automatic backups and can be used for restoring.

Restoring

To restore a database from a backup:

  1. Go to your database's Backups tab
  2. Select the backup you want to restore from
  3. Click Restore

Restoring creates a new database instance from the backup data. Your original database remains untouched.

Point-in-time recovery

With continuous WAL archiving, you can restore to any point in time within the retention window — not just to when a backup was taken. This is useful for recovering from accidental data modifications.

On this page

Automatic backupsManual snapshotsRestoringPoint-in-time recovery