Backup PostgreSQL database running with Docker

backup-database.sh

#!/bin/bash
TIMESTAMP=$(date +"%Y%m%d_%H%M%s")
FILENAME="/var/lib/postgresql/data-backup/$TIMESTAMP.bak"
_ROLE="postgres"
_ENCODING="UTF8"
_DBNAME="mastodon"
docker exec -it mastodon_db_1 \
  pg_dump --username "postgres" \
    --no-password \
    --file "$FILENAME" \
    --role "$_ROLE" \
    --format=c \
    --blobs \
    --compress "3" \
    --section=pre-data \
    --section=data \
    --section=post-data \
    --encoding "$_ENCODING" \
    "$_DBNAME"