backup.sh

# !/bin/bash

backup_dir=""
#String to append to the name of the backup files
backup_date=`date +%d-%m-%Y`

db=""
#Numbers of days you want to keep copie of your databases
pg_dump -b --data-only -T '"SequelizeMeta"' $db>$backup_dir/$db\_$backup_date.sql

# Numbers of days you want to keep the dumps
number_of_days=7
find $backup_dir -type f -name "*.sql" -prune -mtime +$number_of_days -exec rm -f {} \;

cleanup.sh

# !/bin/bash

backup_dir=""

# Numbers of days you want to keep the dumps
number_of_days=7
find $backup_dir -type f -name "*.sql" -prune -mtime +$number_of_days -exec rm -f {} \;

sync.sh

# !/bin/bash

backup_dir=""
key_dir=""
remote_backup_dir="username@hostname:dir/"

rsync -avz -e "ssh -i $key_dir" $backup_dir/*.sql $remote_backup_dir