diff options
-rwxr-xr-x | backup-postgres | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/backup-postgres b/backup-postgres index 8e4e217..afe9782 100755 --- a/backup-postgres +++ b/backup-postgres @@ -14,6 +14,7 @@ set -u DATE=`date "+%Y%m%d-%H%M%S"` CLIENTBASE=/srv/www/vhosts +SYSBASE=/var/backups/local/pg sudo -u postgres psql -l -t | awk '$1 != "" {print $1}' | while read db; do @@ -50,6 +51,22 @@ while read db; do file="$BASE/$DATE-$db.custom" sudo -u postgres pg_dump --blobs --create --format=c "$db" > "$file" nice bzip2 -- "$file" + elif [ "$db" = "postgres" ]; then + file="$SYSBASE/$DATE-$db.plain" + sudo -u postgres pg_dump --create --format=p "$db" > "$file" + nice bzip2 -- "$file" + + md5=`md5sum -- "$file.bz2" | awk '{print $1}'` + if [ -e "$SYSBASE/MD5-$md5" ]; then + rm -- "$file.bz2" + ln "$SYSBASE/MD5-$md5" "$file.bz2" + else + ln "$file.bz2" "$SYSBASE/MD5-$md5" + fi + + file="$SYSBASE/$DATE-$db.custom" + sudo -u postgres pg_dump --blobs --create --format=c "$db" > "$file" + nice bzip2 -- "$file" else echo "Not doing a backup of $db" >&2 fi |