Backup script for PostgreSQL to S3 on Linux
Thanks to: https://zaiste.net/posts/backup_postgresql_to_amazon_s3/ First configure s3: apt-get install s3cmd Set Amazon access & secret keys using –configure option. Enable encryption for data transferring as well as HTTPS. s3cmd –configure #Example of Backup.sh with options for retention (folder name) APP=$1 DB_NAME=$2 DB_USER=$3 DB_PASS=$4 AWS_RET=$5 BUCKET_NAME=”your.s3.backup/$AWS_RET” TIMESTAMP=$(date +%F_%T | tr ‘:’ ‘-‘) TEMP_FILE=$(mktemp XXXXXXXXXX.dump) TEMP_TARGZ=$(mktemp tar.XXXXXXXXXX) S3_FILE=”s3://$BUCKET_NAME/$APP/$APP-backup-$TIMESTAMP.tar.gz” … Leggi tutto