Daily Backup DB

psql.backup.sh

BACKUP_PATH="/backup"

DBNAME="barcamp_dev"

NOW=`date '+%y_%b_%d_%T'`

vacuumdb -w -z -U postgres $DBNAME

pg_dump $DBNAME -w -U postgres | gzip > $BACKUP_PATH/"postgresql-$DBNAME-$NOW.gz"

add to cronjob

1. sudo su to root

2. su to postgres

3. with postgres user, do crontab -e

4. add the back shell script in the file as below

# m h dom mon dow command

14 9 * * * /home/juacompe/projects/barcamp/psql.backup.sh

14 9 * * * touch /backup/testcron