scripts/pgbackup
author Tomas Zeman <tzeman@volny.cz>
Mon, 30 Sep 2013 11:02:46 +0200
changeset 36 738979e906a1
parent 23 5eaf174f21fa
permissions -rw-r--r--
config/.gitconfig: git aliases: man, di, qci, qfin (a.k.a. hg)

#!/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