pg_basebackup cron.daily wrapper script.

postgres-backup.sh

#!/bin/sh -e

BASE="/mnt/backups/postgres"
DEST="$BASE/$(date +%Y-%m-%d-%H%M)"
 AGE="2"

Echo() { date +"%Y-%m-%d %H:%M:%S -- $@"; }

Echo "Mkdir1..."  ;  mkdir -pm710 "$BASE" && chown root:postgres "$BASE"
Echo "Mkdir2..."  ;  mkdir -pm700 "$DEST" && chown      postgres "$DEST"

Echo "Dump..."    ;  sudo -u postgres pg_basebackup -D "$DEST" --checkpoint=fast --verbose
Echo "Compress...";  nice ionice -c3 tar cJf "$DEST.txz" -C "$DEST" .
Echo "SCP..."     ;  scp -q "$DEST.txz" "[email protected]:postgres/in/"

Echo "Delete1..." ;  rm -rf "$DEST"
Echo "Delete2..." ;  find "$BASE/" -maxdepth 1 -type f -mtime +"$AGE" -name "*z" -delete

Echo "Done."

## END ##