Skip to content

Instantly share code, notes, and snippets.

@timcowlishaw

timcowlishaw/gist:d8734bbaa4c9e85a8a24

Last active August 29, 2015 14:14
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save timcowlishaw/d8734bbaa4c9e85a8a24 to your computer and use it in GitHub Desktop.
Save timcowlishaw/d8734bbaa4c9e85a8a24 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sh
#!/usr/bin/env bash
DATABASE_NAME=your_db_name
BACKUP_PATH=/home/you/backups/db
BACKUP_LIMIT=4
pg_dump $DATABASE_NAME | gzip -c > "$BACKUP_PATH"/"$DATABASE_NAME"_`date +"%Y%m%d%H%M"`.sql.gz
BC=$(ls $BACKUP_PATH | wc -l)
if [ "$BC" -ge "$BACKUP_LIMIT" ]; then
ls -t $BACKUP_PATH | tail -$(($BC-$BACKUP_LIMIT)) | xargs -I{} rm $BACKUP_PATH/{}
fi
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment