Script for backuping db

backup-pg.sh

#!/bin/bash

#set -x
set -e

export AWS_ACCESS_KEY_ID="xxxxxxxxxxxxxxx"
export AWS_SECRET_ACCESS_KEY="xxxxxxxxxxxxxxxxx"
export AWS_DEFAULT_REGION="eu-central-1"
export BUCKET="a-b-c-backups"

export DATE=$(date +%Y-%m-%d)
#export DATE=$(date +%Y-%m-%d--%H-%M-%S)
export FILENAME="dump.${DATE}.sql"

# this is not suppression date, but cache expiration date
export EXPIRES=$(date --iso-8601=seconds -d '1 month')
if [[ $(date '+%u') = 6 ]]; then
    # saturday morning backups expires 1y later
    export EXPIRES=$(date --iso-8601=seconds -d '1 year')
fi

rm -rf /tmp/${FILENAME}

docker pull xueshanf/awscli

cd /root/docker/bienavous && /usr/local/bin/docker-compose exec -T postgres pg_dump -U username db_name > /tmp/${FILENAME}

docker run --rm -i \
       -v /tmp:/data \
       -e AWS_ACCESS_KEY_ID=${AWS_ACCESS_KEY_ID} \
       -e AWS_SECRET_ACCESS_KEY=${AWS_SECRET_ACCESS_KEY} \
       -e AWS_DEFAULT_REGION=${AWS_DEFAULT_REGION} \
       xueshanf/awscli \
       aws s3 cp /data/${FILENAME} s3://${BUCKET}/bienavous-pg/${FILENAME} \
       --expires ${EXPIRES} --storage-class STANDARD_IA

rm -rf /tmp/${FILENAME}

crontab:

0 4 * * * /root/backup-scripts/pg-bienavous.sh >> /root/backup-scripts/logs/pg-bienavous.log 2>&1