SQL & databasesBash

Postgres – Backup & Rotate (Bash)

Back up PostgreSQL databases and rotate saved copies.

Bash
#!/usr/bin/env bash
set -euo pipefail
DEST="/var/backups/postgres"
RET=7
mkdir -p "$DEST"
STAMP=$(date +%F_%H%M)
pg_dumpall -U postgres | gzip > "$DEST/pg-$STAMP.sql.gz"
ls -1t "$DEST"/pg-*.sql.gz | tail -n +$((RET+1)) | xargs -r rm -f
  

From Joseph Nakhle's automation workbench.

More SQL & databases scripts