dhis on docker postgres back up

db_backup.sh

#!/bin/bash

# run sudo aws configure first!
# then schedule like this: sudo crontab -e 
# 0 0 * * * /opt/scripts/db_backup.sh # take a backup every midnight
RETENTION_DAYS=14
BUCKET=org.rti-ghd.notresante
DIR=`date +%d-%m-%y`
DEST=./db_backups/$DIR
mkdir $DEST

PGPASSWORD='dhis' docker exec dhis2-database pg_dump  --inserts --column-inserts --username=dhis dhis > $DEST/dbbackup.sql

# remove old backups
old_backup=$(date --date="$RETENTION_DAYS days ago" +"%Y-%m-%d")
rm -rf $old_backup

aws s3 sync ./db_backups s3://$BUCKET
~