Snippets
Dump Script
cd /var/lib/postgresql/dumps rm dump-`date -d yesterday +%Y%m%d`.sql.bz2 2> /dev/null mv dump-`date +%Y%m%d`.sql.bz2 dump-`date -d yesterday +%Y%m%d`.sql.bz2 2> /dev/null nice /usr/bin/pg_dumpall --clean --username=postgres --file=dump-`date +%Y%m%d`.sql nice bzip2 dump-`date +%Y%m%d`.sql