X-Git-Url: http://git.hcoop.net/hcoop/scripts.git/blobdiff_plain/bf301371e226b795b2533bffa3d5a38a006c035b..38eaa16a8d7343b3a93186c385029dcb6cef52f5:/hcoop-all-db-backup

diff --git a/hcoop-all-db-backup b/hcoop-all-db-backup
index 9db1b1d..d0a9a10 100755
--- a/hcoop-all-db-backup
+++ b/hcoop-all-db-backup
@@ -5,7 +5,7 @@
 # docelic@hcoop.net, Tue Aug 28 13:38:26 EDT 2007
 #
 
-BACKUP_ROOT=/var/backups/databases
+BACKUP_ROOT=/srv/backup/database
 BACKUP_DAYS=7
 
 if ! test -d "$BACKUP_ROOT"; then
@@ -13,16 +13,19 @@ if ! test -d "$BACKUP_ROOT"; then
 	exit 1
 fi
 
-MYSQL_DBS=`sudo -H mysqlshow | tail -n +4 | head -n -1 | cut -d' ' -f 2 | xargs`
+# change cwd; default will be /root which postgres user can't chdir into
+cd /tmp
+
+MYSQL_DBS=`sudo -H mysql -Bse 'show databases' | xargs`
 echo "Mysql Databases are: $MYSQL_DBS"
-PGSQL_DBS=`sudo -u postgres psql template1 -c '\l' | tail -n +4 | head -n -2 | cut -d' ' -f 2 | xargs`
+PGSQL_DBS=`sudo -u postgres psql template1 -tAc 'SELECT datname FROM pg_database WHERE datistemplate = false;' | xargs`
 echo "Postgres Databases are: $PGSQL_DBS"
 
 # Delete oldest
 rm -rf "$BACKUP_ROOT/mysql.$BACKUP_DAYS"
-rm -rf "$BACKUP_ROOT/postgres.$BACKUP_DAYS"
+rm -rf "$BACKUP_ROOT/postgres-9.$BACKUP_DAYS"
 
-# Rotate abckup dirs
+# Rotate backup dirs
 for day in `seq $BACKUP_DAYS -1 1`; do
 	to=".$day"
 	let day_before=" $day - 1"
@@ -33,19 +36,21 @@ for day in `seq $BACKUP_DAYS -1 1`; do
 	fi
 
 	mv -f "$BACKUP_ROOT/mysql$from" "$BACKUP_ROOT/mysql$to" 2>/dev/null
-	mv -f "$BACKUP_ROOT/postgres$from" "$BACKUP_ROOT/postgres$to" 2>/dev/null
+	mv -f "$BACKUP_ROOT/postgres-9$from" "$BACKUP_ROOT/postgres-9$to" 2>/dev/null
 done
 
+# backups should not be world-readable, mask all o permissions
+umask 0027
+
 # Create current dump dirs
-mkdir --mode=770 "$BACKUP_ROOT/mysql" "$BACKUP_ROOT/postgres"
+mkdir --mode=770 "$BACKUP_ROOT/mysql" "$BACKUP_ROOT/postgres-9"
 
 # Perform MYSQL backup
-for db in $MYSQL_DBS; do 
-	sudo -H mysqldump "$db" | gzip - > "$BACKUP_ROOT/mysql/$db.gz"
+for db in $MYSQL_DBS; do
+	sudo -H mysqldump --single-transaction "$db" | pigz - > "$BACKUP_ROOT/mysql/$db.gz"
 done
 
 # Perform PGSQL backup
-for db in $PGSQL_DBS; do 
-	sudo -H -u postgres pg_dump "$db" | gzip - > "$BACKUP_ROOT/postgres/$db.gz"
+for db in $PGSQL_DBS; do
+	sudo -H -u postgres pg_dump -Fc "$db" > "$BACKUP_ROOT/postgres-9/$db.pg"
 done
-