Skip to content

Instantly share code, notes, and snippets.

@ecarreras
Created September 22, 2012 20:11
Show Gist options
  • Save ecarreras/3767662 to your computer and use it in GitHub Desktop.
Save ecarreras/3767662 to your computer and use it in GitHub Desktop.
Some backup scripts
0 0 * * * /usr/bin/duplicity --no-encryption /home scp://$(hostname -s)@vampir//mnt/backup/servers/$(hostname -s)
#!/bin/sh
export PATH=$PATH:/usr/bin
LOCKFILE=/home/dbdumps/dumping.lock
touch $LOCKFILE
for DB in `psql -lAt | grep -v template | cut -d '|' -f1`; do
pg_dump --no-owner $DB | bzip2 > /home/dbdumps/$DB.sql.bz2
done
rm $LOCKFILE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment