backup_db.sh

#!/bin/bash
##
# needs these env:
# FILENAME_PREFIX: prefix on basename of file to iterate over
# DBNAME: psql database name on local machine (or uri)

# default: 40
KEEP_BACKUPS=${KEEP_BACKUPS:-40}


pg_dump $DBNAME | gzip -9 > "$HOME/$FILENAME_PREFIX-`date +%d%m%YT%H%M`.sql.gz"

DELETE_BACKUPS=$(ls -t "$HOME/" | tac | grep "$FILENAME_PREFIX" | grep ".sql.gz" | head -n"-$KEEP_BACKUPS")

if [ -n "$DELETE_BACKUPS" ]; then
        rm $DELETE_BACKUPS
fi

exec ./diff_to_gsutil.sh