# HG changeset patch
# User Tomas Zeman <tzeman@volny.cz>
# Date 1346321429 -7200
# Node ID 5eaf174f21fa23d4a3706bba1fcc1943bd64bee7
# Parent  2e2d65a997abf8f0524eb4dc6ec7d895f6d18457
scripts/pgbackup

diff -r 2e2d65a997ab -r 5eaf174f21fa scripts/pgbackup
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/scripts/pgbackup	Thu Aug 30 12:10:29 2012 +0200
@@ -0,0 +1,13 @@
+#!/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
+