dokku postgres backupscript

backup-db.sh

#! /bin/bash
#
# to restore:
#   gunzip XXX.db.gz
#   dokku postgres:import <dbname> < XXX.db

# directory to save backups in, must be rwx by postgres user
BASE_DIR="/var/backups/postgres"
YMD=$(date "+%Y-%m-%d")
DIR="$BASE_DIR"
mkdir -p $DIR
cd $DIR

# make database backup
dokku postgres:export $1 | gzip -9 > "$YMD.db.gz"

# delete backup files older than 7 days
OLD=$(find $BASE_DIR -type f -mtime +7)
if [ -n "$OLD" ] ; then
        echo deleting old backup files: $OLD
        echo $OLD | xargs rm -rfv
fi

crontab

0 0 * * * /root/backup-db.sh huginn