postgresql daily backup at 1:00 AM

crontab

0 1 * * * /backups/backup.sh >/dev/null 2>&1

postgresql-backup.sh

#!/bin/bash

ignore_images_number=10
counter=1
DATE_FORMAT='+%Y-%m-%d--%H-%M'
ls /backups | grep '.sql' | sort -hr | column -t | while read line; do
    if [ $counter -gt $ignore_images_number ]
    then
        {
            rm -rf /backups/$line
            } || {
            echo -e "${RED}Error While Deleteing backup.${NC}"
        }
    fi
    counter=$((counter+1))
done

PGPASSWORD="test_password" pg_dump -h 127.0.0.1 -U test_user -d test_db -v > /backups/`date ${DATE_FORMAT}.sql`