Backups

deploy/backup.sh dumps Postgres in pg_dump custom format, compressed and restorable table by table, keeping 14 days. Run it from cron on the host:

0 3 * * * /opt/myapp/deploy/backup.sh >> /var/log/myapp-backup.log 2>&1

Tune it with BACKUP_DIR and BACKUP_KEEP_DAYS.

Restoring

docker compose exec -T db pg_restore -U myapp -d myapp --clean < backups/myapp-<stamp>.dump

Get the dump off the machine

A backup on the same disk as the database is not a backup.

Add a step that copies the dump elsewhere, to object storage or another host, and consider encrypting it on the way out:

openssl enc -aes-256-cbc -pbkdf2 -pass file:/root/.backup.key \
    -in "$dump" -out "$dump.enc" && rm "$dump"

Everything that matters lives in Postgres and your object storage. The containers and Redis are disposable. The dumps are not.

Restore one dump before you need to. An untested backup has not been shown to work.

Get started

Tutorial: build a Kanban app

Building the UI

Backend

Features

Tooling

Testing

Deployment

Restoring

Get the dump off the machine

​Restoring

​Get the dump off the machine

Restoring

Get the dump off the machine