From 243f292f7f564a31b976f11994435fcfc05539bf Mon Sep 17 00:00:00 2001
From: Johan Lundberg <lundberg@nordu.net>
Date: Wed, 1 Apr 2015 14:24:47 +0200
Subject: Added postgres backup script and updated cron jobs.

---
 .../overlay/usr/local/bin/postgres_backup          | 30 ++++++++++++++++++++++
 1 file changed, 30 insertions(+)
 create mode 100755 sto-tug-kvm2.swamid.se/overlay/usr/local/bin/postgres_backup

(limited to 'sto-tug-kvm2.swamid.se/overlay/usr/local')

diff --git a/sto-tug-kvm2.swamid.se/overlay/usr/local/bin/postgres_backup b/sto-tug-kvm2.swamid.se/overlay/usr/local/bin/postgres_backup
new file mode 100755
index 0000000..9749390
--- /dev/null
+++ b/sto-tug-kvm2.swamid.se/overlay/usr/local/bin/postgres_backup
@@ -0,0 +1,30 @@
+#
+# Simplistic postgres backup
+#
+
+BACKUPROOT="/var/docker/postgres_data/backup/"
+DBCONTAINER="flog_db"
+
+if [ ! -d ${BACKUPROOT} ]; then
+    echo "$0: Directory ${BACKUPROOT} does not exist - aborting."
+    exit 1
+fi
+
+set -e
+
+# keep seven days worth of dumps
+rm -rf ${BACKUPROOT}/postgres-dumpall-flogdb.gz.7
+test -d ${BACKUPROOT}/postgres-dumpall-flogdb.gz.6 && mv ${BACKUPROOT}/postgres-dumpall-flogdb.gz.6 ${BACKUPROOT}/postgres-dumpall-flogdb.gz.7
+test -d ${BACKUPROOT}/postgres-dumpall-flogdb.gz.5 && mv ${BACKUPROOT}/postgres-dumpall-flogdb.gz.5 ${BACKUPROOT}/postgres-dumpall-flogdb.gz.6
+test -d ${BACKUPROOT}/postgres-dumpall-flogdb.gz.4 && mv ${BACKUPROOT}/postgres-dumpall-flogdb.gz.4 ${BACKUPROOT}/postgres-dumpall-flogdb.gz.5
+test -d ${BACKUPROOT}/postgres-dumpall-flogdb.gz.3 && mv ${BACKUPROOT}/postgres-dumpall-flogdb.gz.3 ${BACKUPROOT}/postgres-dumpall-flogdb.gz.4
+test -d ${BACKUPROOT}/postgres-dumpall-flogdb.gz.2 && mv ${BACKUPROOT}/postgres-dumpall-flogdb.gz.2 ${BACKUPROOT}/postgres-dumpall-flogdb.gz.3
+test -d ${BACKUPROOT}/postgres-dumpall-flogdb.gz.1 && mv ${BACKUPROOT}/postgres-dumpall-flogdb.gz.1 ${BACKUPROOT}/postgres-dumpall-flogdb.gz.2
+
+echo "Running postgres pg_dumpall..."
+
+cd ${BACKUPROOT}
+/usr/bin/docker exec ${DBCONTAINER} sudo -u postgres /usr/bin/pg_dumpall | /bin/gzip > postgres-dumpall-flogdb.gz
+
+mv ${BACKUPROOT}/postgres-dumpall-flogdb.gz ${BACKUPROOT}/postgres-dumpall-flogdb.gz.1
+
-- 
cgit v1.1