docker_postgres_backup.sh

#!/bin/bash
#
# Dockerized Mastodon Database Backup Script
#

DIR=$(date +%d-%m-%y)
DEST="./db_backups/$DIR"
mkdir -p "$DEST"

MASTODON_ENV=$(basename "${PWD}")

. database.env
HOST=$(docker inspect "${MASTODON_ENV}-postgresql-1" | jq -r ".[].NetworkSettings.Networks[\"${MASTODON_ENV}_internal_network\"].IPAddress")

docker-compose run --env PGPASSWORD="$POSTGRES_PASSWORD" --rm postgresql \
	pg_dump \
		--inserts \
		--column-inserts \
		--username="$POSTGRES_USER" \
		--host="$HOST" \
		--port="$DB_PORT" "$POSTGRES_DB" | gzip -c -9 > "${DEST}/dbbackup.sql.gz"