Guides
How to keep database backups you can restore. Most use standard tools and work without SafeGrd.
Supabase
How to back up Supabase with GitHub Actions
A nightly encrypted backup and a weekly restore test, both in GitHub Actions.
Supabase project down: get running from your own backup
A new project from your own backup when Supabase's restore is blocked.
pg_dump errors on Supabase, and the one that does not error
The dump that exits 0 with rows missing under row-level security, and the fix for each error pg_dump gives on Supabase.
Restore a Supabase dump outside Supabase, and check what came back
The image, the role and the checks that restore a Supabase dump with no errors, and the policy a plain Postgres restore leaves out.
Supabase backup tools compared
Eleven ways to back up Supabase: which keep the Storage files, where the copy lives, and which test the restore.
PostgreSQL, SQLite and MongoDB
How to back up PostgreSQL to S3 with pg_dump
An encrypted backup script for a locked bucket, and the restore command.
pg_dump, pg_basebackup or pgBackRest
Logical or physical backups, what each restores to, and which to run first.
PostgreSQL backup tools compared
Nine tools, what each does best, and how its restores get tested.
Restore a Postgres backup without bringing back deleted users
Replay the erasures made after the backup, and keep pg_cron's jobs from starting.
SQLite WAL mode, and how to back it up
Why copying app.db lost 500 of 1,500 rows, and three backups that do not.
Know when Coolify's database backups stop working
Check the age, size and restore of each backup Coolify writes, by script or with SafeGrd.
What MongoDB Atlas backups cost, and how to work out your bill
Snapshot storage, point-in-time restore, export and egress on Atlas, from MongoDB's price tables, with a 50 GB cluster worked through.
Lock, test and prove a backup
Immutable backups with S3 Object Lock
Setting up a locked bucket, what retention costs, and what a lock does not protect.
Database backups an AI coding agent cannot delete
Four steps to backups an agent with your credentials cannot delete.
How to test that a PostgreSQL or MySQL backup restores
Four levels of checking, from a checksum to a full restore, and what each catches.
RPO and RTO for a database backup
What sets each for a database, how to measure yours, and how to lower them.
Restore-test evidence for SOC 2 and security questionnaires
What A1.2 and A1.3 ask about backups, and what a restore-test record must hold.
By database and platform
The provider's own backup and its limits, then the role, the backup and the restore: PostgreSQL, MySQL and MariaDB, MongoDB, Supabase, Neon, Railway, Render, Fly.io, DigitalOcean, Hetzner, Amazon RDS, Heroku and Coolify.
Comparisons
- SafeGrd vs AWS Backup: what checks the data after a test restore.
- SafeGrd vs SimpleBackups: where the data flows and how each tests a restore.
- SafeGrd vs pgBackRest: physical backups, or logical ones tested by restoring.
- SafeGrd vs Barman: one backup server, or a tested copy from each host.
- SafeGrd vs BackupDrill: drills for Supabase only, or for every database on your host.
- SafeGrd vs Databasus: a free self-hosted tool, or locked storage with a signed record.
- SafeGrd vs Ottomatik: backups over SSH with capped jobs, or uncounted ones on your host.