DB Backup

mastodon_db_backup.sh

#!/bin/bash

set -e

. /etc/default/backup

INSTANCE=$1

case $INSTANCE in

  ft-relay)
    PG_DB_NAME=ft_relay
    PG_USERNAME=ft_relay
    ;;

  ptzo-masto)
    PG_DB_NAME=mastodon_production
    PG_USERNAME=mastodon
    ;;

  walkman-masto)
    PG_DB_NAME=walkman_production
    PG_USERNAME=walkman
    ;;

  *)
    echo Instance code $INSTANCE unknown.
    exit 1
    ;;
esac

S3PATH=ph/backups/db/$(hostname)/$(date +%Y)/$(date +%m)/$(date +%d)

TARGETFILE=$INSTANCE.sql.gz
WORKDIR=/var/lib/backup

rm -f $WORKDIR/$TARGETFILE
rm -f $WORKDIR/$TARGETFILE.gpg

echo Dumping Database
pg_dump -h localhost -U $PG_USERNAME -p 5432 $PG_DB_NAME | nice gzip > $WORKDIR/$TARGETFILE

echo Encrpyting File
gpg --yes --batch --passphrase=$GPG_PASSWORD -c $WORKDIR/$TARGETFILE

echo Uploading to Cloud
/usr/local/bin/mc cp $WORKDIR/$TARGETFILE.gpg $S3PATH/$TARGETFILE.gpg

echo Vacuuming Database
/usr/bin/psql -h localhost -U vacuum -p 5432 $PG_DB_NAME -c 'VACUUM FULL VERBOSE;'

rm -f $WORKDIR/$TARGETFILE
rm -f $WORKDIR/$TARGETFILE.gpg