entrypoint.sh

#!/bin/bash
set -e

echo "Prepare configuration for script"
TIMESTAMP=$(date +%F_%R)
START_TIMESTAMP=$(date +%s)
BACKUP_FILE=${DB_NAME}-${TIMESTAMP}.sql.gz
BACKUP_FILE_LATEST=${DB_NAME}-latest.sql.gz
DB_HOST=${DB_HOST:-localhost}
DB_PASSWORD=$(cat ${DB_PASSWORD_FILE})
DB_USER=$(cat ${DB_USERNAME_FILE})
PROM_NAMESPACE=${PROM_NAMESPACE:-dboperator}

if [[ -z "${STORAGE_BUCKET}" ]]; then
  echo "Variable STORAGE_BUCKET must be set"
  exit 1
fi

# create login credential file
(umask 377 && echo *:5432:*:${DB_USER}:${DB_PASSWORD} >> ~/.pgpass)

echo "Backing up"
pg_dump -F c -Z 9 -h ${DB_HOST} -p 5432 -U ${DB_USER} ${DB_NAME} -f ${BACKUP_FILE}
BACKUP_SIZE=$(du ${BACKUP_FILE} | awk '{print $1}')

## copy to destination
echo "Uploading to a storage"
rclone copyto "./${BACKUP_FILE}" "storage://${STORAGE_BUCKET}/${DB_NAME}/${BACKUP_FILE}" 
rclone copyto "./${BACKUP_FILE}" "storage://${STORAGE_BUCKET}/${DB_NAME}/${BACKUP_FILE_LATEST}" 

END_TIMESTAMP=$(date +%s)
BACKUP_DURATION=$((END_TIMESTAMP - START_TIMESTAMP))
if [[ ! -z "$PROMETHEUS_PUSH_GATEWAY" ]];
then
echo "sending monitoring metrics to ${PROMETHEUS_PUSH_GATEWAY}"
cat <<EOF | curl -s --data-binary @- http://${PROMETHEUS_PUSH_GATEWAY}/metrics/job/pgdump-rclone/source_type/postgresql/source_name/${DB_NAME}
    # TYPE ${PROM_NAMESPACE}_backup_timestamp counter
    # HELP ${PROM_NAMESPACE}_backup_timestamp Timestamp of last backup run
    ${PROM_NAMESPACE}_backup_timestamp $END_TIMESTAMP
    # TYPE ${PROM_NAMESPACE}_backup_duration gauge
    # HELP ${PROM_NAMESPACE}_backup_duration Time the backup run take until finished
    ${PROM_NAMESPACE}_backup_duration $BACKUP_DURATION
    # TYPE ${PROM_NAMESPACE}_backup_size gauge
    # HELP ${PROM_NAMESPACE}_backup_size Backup Size in bytes
    ${PROM_NAMESPACE}_backup_size $BACKUP_SIZE
EOF
fi