--- /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
+