From e9f06d2ec17be72874fa30f310f8f41bbd695530 Mon Sep 17 00:00:00 2001 From: Johan Lundberg Date: Thu, 23 Apr 2015 15:27:30 +0200 Subject: Moving postgres backup script in to container. --- .../overlay/etc/cron.d/flog_daily | 2 +- .../overlay/usr/local/bin/postgres_backup | 32 ---------------------- 2 files changed, 1 insertion(+), 33 deletions(-) delete mode 100755 sto-tug-kvm2.swamid.se/overlay/usr/local/bin/postgres_backup (limited to 'sto-tug-kvm2.swamid.se') diff --git a/sto-tug-kvm2.swamid.se/overlay/etc/cron.d/flog_daily b/sto-tug-kvm2.swamid.se/overlay/etc/cron.d/flog_daily index 0759dca..5878023 100644 --- a/sto-tug-kvm2.swamid.se/overlay/etc/cron.d/flog_daily +++ b/sto-tug-kvm2.swamid.se/overlay/etc/cron.d/flog_daily @@ -1,6 +1,6 @@ # m h dom mon dow user command 0 23 * * * root /usr/local/bin/scriptherder --mode wrap --name flog_update_institutions -- /usr/bin/curl https://meta.eduroam.se/institution.xml -so /opt/flog/institution.xml -1 0 * * * root /usr/local/bin/scriptherder --mode wrap --syslog --name flog_db_backup -- /usr/local/bin/postgres_backup +1 0 * * * root /usr/local/bin/scriptherder --mode wrap --syslog --name flog_db_backup -- docker exec flog_db /usr/local/bin/backup # Run aggregation and caching for eduroam data 20 0 * * * root /usr/local/bin/scriptherder --mode wrap --name flog_daily_eduroam -- /usr/bin/docker run --rm -it -a stdout -a stderr -v /opt/flog/dotenv:/opt/flog/.env -v /var/log/flog_cron/:/opt/flog/logs/ -v /opt/flog/institution.xml:/opt/flog/institution.xml -v /opt/flog/dotenv:/opt/flog/.env -v /etc/passwd:/etc/passwd:ro -v /etc/group:/etc/group:ro --link flog_db:flog_db.docker docker.sunet.se/flog/flog_app /bin/sh -e /usr/local/bin/daily_eduroam # Run aggregation and caching for sso data 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 deleted file mode 100755 index a2b4986..0000000 --- a/sto-tug-kvm2.swamid.se/overlay/usr/local/bin/postgres_backup +++ /dev/null @@ -1,32 +0,0 @@ -#!/usr/bin/env bash -# -# Simplistic postgres backup -# -set -e - -BACKUPROOT="/var/docker/postgresql_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 -f ${BACKUPROOT}/postgres-dumpall-flogdb.gz.6 && mv ${BACKUPROOT}/postgres-dumpall-flogdb.gz.6 ${BACKUPROOT}/postgres-dumpall-flogdb.gz.7 -test -f ${BACKUPROOT}/postgres-dumpall-flogdb.gz.5 && mv ${BACKUPROOT}/postgres-dumpall-flogdb.gz.5 ${BACKUPROOT}/postgres-dumpall-flogdb.gz.6 -test -f ${BACKUPROOT}/postgres-dumpall-flogdb.gz.4 && mv ${BACKUPROOT}/postgres-dumpall-flogdb.gz.4 ${BACKUPROOT}/postgres-dumpall-flogdb.gz.5 -test -f ${BACKUPROOT}/postgres-dumpall-flogdb.gz.3 && mv ${BACKUPROOT}/postgres-dumpall-flogdb.gz.3 ${BACKUPROOT}/postgres-dumpall-flogdb.gz.4 -test -f ${BACKUPROOT}/postgres-dumpall-flogdb.gz.2 && mv ${BACKUPROOT}/postgres-dumpall-flogdb.gz.2 ${BACKUPROOT}/postgres-dumpall-flogdb.gz.3 -test -f ${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