Created: December 09, 2018 09:56 | Updated: December 16, 2018 08:32
Tags: Heroku, Linux, Rails 5, Shell Scripting, Postgres
Please note that since writing this article I have created a shell script that downloads all your Heroku and Dokku Postgres databases and uploads them to Google Drive. You can check it out here.
If your Heroku app isn’t professional tier, backups get a little more labour intensive. You will need to manually backup and download your databases and store them yourself.To help me do this, I wrote a shell script.
First you need to create a shell script
touch backupdb.sh
open it
gedit backupdb.sh
Paste in the following code (Just replace the app1 app2 app3 etc. with the names of the apps you with to back up).
The script:
#!/bin/bash
apps=(app1 app2 app3)
DATE=`date +%Y-%m-%d`
mkdir -p "${DATE}"
for i in ${apps[@]}; do
heroku pg:backups:capture --app ${i}
url=$(heroku pg:backups:url --app ${i})
wget -O $DATE/${i} $url
done
Make the script executable
chmod +x backupdb.sh
and run it!
./backupdb.sh
Check out Heroku for more indepth information
Written by Alan Vardy. Let me know how I can make this better!