Postgres backup with gzip support and upload to S3/Digital Ocean Spaces

postgres-bkp.sh

#!/bin/bash

WORKSPACE_DIR="/tmp/postgres_bkp"
DB_URL="$1"
BACKUP_FILENAME="$2"
S3_CMD=$(which s3cmd)
SPACES_BUCKET="your-bucket-here"

if [ -z "$DB_URL" ] || [ -z "$BACKUP_FILENAME" ]; then
  echo "You must set database connection and output filename !!!";
  echo "eg: ./postgres-bkp.sh DATABASE_URL backup_filename";
  exit 1;
fi

if [ ! -d "$WORKSPACE_DIR" ]; then
  echo "creating workspace at $WORKSPACE_DIR"
  mkdir -p $WORKSPACE_DIR
fi

echo "Running backup for $DB_URL."

DUMP_SUFFIX="$(date +'%F_%H_%M')"
OUTPUT_FILENAME="$BACKUP_FILENAME-$DUMP_SUFFIX.sql.gz"
OUTPUT_PATH="$WORKSPACE_DIR/$OUTPUT_FILENAME"
pg_dump $DB_URL --no-owner | gzip > "$OUTPUT_PATH"

echo "Sending backup to S3/Digital Ocean Spaces."
SPACES_PATH="$(date +"%Y")/$(date +"%m")/$OUTPUT_FILENAME"
$S3_CMD put "$OUTPUT_PATH" s3://"$SPACES_BUCKET/$SPACES_PATH"

echo "Cleaning up workspace"
find "$WORKSPACE_DIR" -type f -name "*.sql.gz" -exec rm -f {} \;

echo "Backup finished !!!"