source: trunk/packages/xvm-db-backup/xvm-db-backup @ 2935

Last change on this file since 2935 was 2536, checked in by broder, 15 years ago

In xvm-db-backup:

  • Let the config file specify a list of tables to exclude from the backup.
  • Property svn:executable set to *
File size: 779 bytes
Line 
1#!/bin/bash
2
3set -e
4
5kinit -k "daemon/$(hostname -f)"
6aklog sipb
7
8db_filename="/mit/xvm/backups/db/prod/$(date +%Y/%m/%d.%H%M.sql.gz)"
9mkdir -p "$(dirname $db_filename)"
10
11exclude=()
12if invirt-getconf db.backup_exclude &>/dev/null; then
13    for i in invirt-getconf -l db.backup_exclude; do
14        exclude=("${exclude[@]}" -T "$(invirt-getconf "db.backup_exclude.$i")")
15    done
16fi
17/usr/bin/pg_dump -U "$(invirt-getconf db.user)" \
18                 -h "$(invirt-getconf db.host)" \
19                 "${exclude[@]}" \
20                 "$(invirt-getconf db.dbname)" | gzip - >"$db_filename"
21
22running_filename="/mit/xvm/log/running/prod/$(date +%Y/%m/%d.%H%M.gz)"
23mkdir -p "$(dirname $running_filename)"
24
25remctl "$(invirt-getconf remote.hostname)" web listvms | gzip - >"$running_filename"
Note: See TracBrowser for help on using the repository browser.