Skip to content

Instantly share code, notes, and snippets.

@luodaoyi
Forked from roylez/backup-db.sh
Created August 23, 2018 05:08
Show Gist options
  • Save luodaoyi/91af678af2fb1cd92ac1ea2b1fc1ca11 to your computer and use it in GitHub Desktop.
Save luodaoyi/91af678af2fb1cd92ac1ea2b1fc1ca11 to your computer and use it in GitHub Desktop.
dokku postgres backupscript
#! /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
0 0 * * * /root/backup-db.sh huginn
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment