Micro pg_dump backup script

db_backup.sh

#!/usr/bin/env bash

backup_dir=/var/backups
database=dscout_production

mkdir -p "$backup_dir" || exit 1
filename="$database-$(date +%Y-%m-%d).dump"

echo "Backing up $database ..."
pg_dump -Fc -f "$backup_dir/$filename" $database

echo "Removing old backups"
cd "$backup_dir" || exit 1
find . -type f -mtime +6 -delete
find . -type d -delete 2>/dev/null