svn commit helper (displays diff); diff must be manually deleted before committing the changes
#!/bin/sh -e
# Creates full pgsql backup with symlinks to last and prev backup.
BACKUPDIR=/home/pgsql/backup
N=pg_dumpall-`date +%F`.bz2
F=$BACKUPDIR/$N
pg_dumpall | bzip2 > $F.tmp
mv $F.tmp $F
cd $BACKUPDIR
[ -L last ] && mv last prev
ln -sf $N last