Backup to s3

backup_to_s3.sh

#!/bin/bash

# Setup
PROJECTS=“project1 project2"
AWS_BUCKET_NAME=...
export PGUSER=django
export PGPASSWORD=django

# Perform backup routines
for PROJECT in $PROJECTS;
do
   BACKUP_ROOT=/tmp/backups/
   BACKUP_DIR=${BACKUP_ROOT}${PROJECT}
   mkdir -p ${BACKUP_DIR}
   DT=`date "+%Y-%m-%d@%H%M"`
   pg_dump -O ${PROJECT} | gzip -9 > ${BACKUP_DIR}/${PROJECT}_${DT}.sql.gz
   cd /var/www/${PROJECT}; tar zcf ${BACKUP_DIR}/${PROJECT}_${DT}.tar.gz media
   s3cmd sync ${BACKUP_ROOT} s3://${AWS_BUCKET_NAME}
   rm -rf ${BACKUP_ROOT}
done