scripts/pgbackup
changeset 23 5eaf174f21fa
equal deleted inserted replaced
22:2e2d65a997ab 23:5eaf174f21fa
       
     1 #!/bin/sh -e
       
     2 # Creates full pgsql backup with symlinks to last and prev backup.
       
     3 
       
     4 BACKUPDIR=/home/pgsql/backup
       
     5 N=pg_dumpall-`date +%F`.bz2
       
     6 F=$BACKUPDIR/$N
       
     7 
       
     8 pg_dumpall | bzip2 > $F.tmp
       
     9 mv $F.tmp $F
       
    10 cd $BACKUPDIR
       
    11 [ -L last ] && mv last prev
       
    12 ln -sf $N last
       
    13