Postgres – Backup & Rotate (Bash)
Back up PostgreSQL databases and rotate saved copies.
#!/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