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