PostgreSQL in docker online remote backup script (with encryption) useful for Mastodon

mastodon-docker-postgres-auto-backup.sh

#!/bin/bash

cd /home/ec2-user/mastodon
TMPFILE=$(mktemp)
PASSWORD=xxxxxxx

DAY=$(date +"%a")

docker-compose exec db pg_dump -Z1 -Fc -U postgres postgres | openssl enc -aes-128-ctr -md sha256 -e -pass pass:$PASSWORD > $TMPFILE

rsync -avc --no-compress --progress $TMPFILE [email protected]:pg-backup-$DAY.encrypted

rm -f $TMPFILE

to decrypt:

openssl enc -aes-128-ctr -md sha256 -d -in pg-backup.encrypted -out pg-backup.decrypted