#!/bin/bash
pg_dumpall -f /home/incoming/SQL_Dump.sql
mv /home/Backup/Day1/* /home/Backup/Day2/
mv /home/Backup/Day2/* /home/Backup/Day3/
mv /home/Backup/Day3/* /home/Backup/Day4/
mv /home/Backup/Day4/* /home/Backup/Day5/
mv /home/Backup/Day5/* /home/Backup/Day6/
mv /home/Backup/Day6/* /home/Backup/Day7/
mv /home/Backup/Day7/* /home/Backup/Day8/
mv /home/Backup/Day8/* /home/Backup/Day9/
mv /home/Backup/Day9/* /home/Backup/Day10/
tar zcf /home/Backup/Day1/SQL.tar.gz /home/incoming/SQL_Dump.sql

#!/bin/bash
sql_dump='/home/incoming/SQL_Dump.sql'
backup_dir='/home/Backup'
pg_dumpall -f "$sql_dump"
today="$(date +"%d-%m-%Y")"
tar -czf "${backup_dir}/${today}/SQL_Dump_${today}.tar.gz" "$sql_dump" &&
    rm -f "$sql_dump"
find "$backup_dir"
    -maxdepth 1
    -type d
    ! -regex "${backup_dir}$"
    -ctime +8
    -exec rm -f {} ;