Backup Postgres DB to Google Drive

backup_db.sh

#!/bin/bash

now=`date +%Y%m%d-%H%M%S`
day_ago=7
db_name="DB_NAME"

base_path="BASE_PATH"
dump_fpath="$base_path/backup_db-$now.sql.gz"

sudo -u postgres pg_dump $db_name | gzip -9 > $dump_fpath

find $base_path -maxdepth 1 -type f -name "backup_db*.tar" -mtime +$day_ago -delete

# https://github.com/prasmussen/gdrive
gdrive sync upload $base_path GDRIVE_FOLDER_ID