Heroku database backup to development system - add to crontab

heroku-backup.sh

#!/bin/bash
echo "Backup started" `date`
APPLICATION_DIR=YOUR_APP_DIRECTORY_GOES_HERE
BACKUP_DIR=YOUR_BACKUP_DIRECTORY_GOES_HERE
cd ${APPLICATION_DIR} 
heroku pgbackups:capture --expire
URL=`heroku pgbackups:url`
URL=${URL//\"/}
echo $URL
curl -o $BACKUP_DIR`date +"db_dump_%Y%m%d%H"` ${URL}
echo "Backup completed" `date`