Back up postgres db to google cloud storage

ps-snapshot.sh

#!/bin/bash
# Requirements:
#   - gcloud/gsutil is installed on the box
#   - gcloud is logged in as a user with write access to Google Cloud Storage
#   - The file has execution rights so that it can be run in cron
#   - The Google Cloud Storage bucket already exits


# Exit on any error
set -e

BUCKET='gs://some-bucket/'
JOB_TIMESTAMP=`date +%Y%m%d-%H%M`
DATABASE='the database name'
DIR='/home/postgres'

cd $DIR

/usr/bin/pg_dump $DATABASE > $JOB_TIMESTAMP-pad.sql

/bin/tar -cvzf $JOB_TIMESTAMP.tar.gz $JOB_TIMESTAMP-pad.sql
/usr/bin/gsutil cp $JOB_TIMESTAMP.tar.gz $BUCKET

rm -f $JOB_TIMESTAMP-pad.sql $JOB_TIMESTAMP.tar.gz