annotate scripts/backup-container.sh @ 279:d6d8468441b1

use container id's and inspect to derive projet and container names
author smith@nwoca.org
date Thu, 15 Nov 2018 19:48:02 +0000
parents 7723b18b112b
children 7710677f147c
rev   line source
54
334d65dac778 add hash bangs to specify bash shell
smith@nwoca.org
parents: 28
diff changeset
1 #!/bin/bash
159
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
2 # Executes a database backup for the specifed database container.
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
3 # The current directory is expected to contaion a project configured
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
4 # as with SSDT conventions for an application database.
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
5 #
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
6 # When successful, the output file will be in ./backup with the
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
7 # container name and timestamp in the file. The format of the output
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
8 # is a compressed pg_dump (sql) format.
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
9 #
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
10 container=${1?Must provide container name to backup}
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
11
188
2f5f41d237e7 DEP-12: fix backup script.
smith@nwoca.org
parents: 186
diff changeset
12 projectDir=${2:-$PWD}
2f5f41d237e7 DEP-12: fix backup script.
smith@nwoca.org
parents: 186
diff changeset
13
2f5f41d237e7 DEP-12: fix backup script.
smith@nwoca.org
parents: 186
diff changeset
14 cd $projectDir
2f5f41d237e7 DEP-12: fix backup script.
smith@nwoca.org
parents: 186
diff changeset
15
159
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
16 source "${SSDT_SCRIPTS:-$(dirname "${BASH_SOURCE[0]}")}/.functions.sh"
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
17
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
18 set -o pipefail
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
19 mkdir -p ./backup
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
20 backupFile=./backup/${container}.$(date +%Y-%m-%d-%H-%M-%S).backup
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
21
274
7723b18b112b add debuging logic for omeresa
smith@nwoca.org
parents: 267
diff changeset
22 echo "preparing to backup ${container} on current project at ${projectDir}:"
7723b18b112b add debuging logic for omeresa
smith@nwoca.org
parents: 267
diff changeset
23 docker-compose ps
7723b18b112b add debuging logic for omeresa
smith@nwoca.org
parents: 267
diff changeset
24 echo " "
7723b18b112b add debuging logic for omeresa
smith@nwoca.org
parents: 267
diff changeset
25
267
fcee81af7e71 simplify method of getting project name
smith@nwoca.org
parents: 188
diff changeset
26 project=$(composeGetProject)
159
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
27
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
28 if [ "$project" == "" ]; then
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
29 echo "no project available"
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
30 exit 1
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
31 fi
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
32
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
33 echo "starting backup of $container for $project"
188
2f5f41d237e7 DEP-12: fix backup script.
smith@nwoca.org
parents: 186
diff changeset
34 docker-compose exec -T $container sh -c "gosu postgres pg_dump -Cc --if-exists --dbname=$container ; (exit $?) " > ${backupFile}
159
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
35
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
36 if [[ $( grep --count "CREATE TABLE" ${backupFile} ) -lt 200 || $( grep --count "PostgreSQL database dump complete" ${backupFile} ) -eq 0 ]]; then
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
37 echo "ERROR: backup verification FAILED"
267
fcee81af7e71 simplify method of getting project name
smith@nwoca.org
parents: 188
diff changeset
38 echo "ERROR: $(tail ${backupFile})"
159
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
39 exit 1
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
40 fi
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
41
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
42 gzip ${backupFile}
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
43
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
44
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
45 echo "completed backup of $container for $project to ${backupFile}"
303259c08b7d DEP-12: update backup scripts
smith@nwoca.org
parents: 54
diff changeset
46