ptzo_backup_database.sh

gistfile1.txt

#!/bin/bash

. /etc/default/backup

S3PATH=do/ptzo-backups/ptzo/db/$(date +%d)
TARGETFILE=ptzo.sql.gz
WORKDIR=/var/lib/backup

rm $WORKDIR/$TARGETFILE
rm $WORKDIR/$TARGETFILE.gpg

echo Dumping Database
pg_dump -h localhost -U mastodon -p 35432 mastodon_production | nice gzip > $WORKDIR/$TARGETFILE

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

mc cp $WORKDIR/$TARGETFILE.gpg $S3PATH/$TARGETFILE.gpg