Mercurial > public > ssdt-docker
comparison scripts/remote-backup.sh @ 293:95d7d70f34a5 production v2.4.0
flow: Merged <release> 'v2.4.0' to <master> ('production').
author | smith@nwoca.org |
---|---|
date | Thu, 27 Dec 2018 00:06:14 +0000 |
parents | 4cc087cde1d0 |
children | d78b45c28205 |
comparison
equal
deleted
inserted
replaced
285:cd2e677afa4e | 293:95d7d70f34a5 |
---|---|
1 #!/bin/bash | |
2 # Executes a database backup for the specified database container. | |
3 # The current directory is expected to contain a project configured | |
4 # as with SSDT conventions for an application database. | |
5 # | |
6 # When successful, the output file will be in ./backup with the | |
7 # container name and timestamp in the file. | |
8 # The file will also be placed on the specified remote target | |
9 # The format of the output is a compressed pg_dump (sql) format. | |
10 # along with the top level contents of the project directory | |
11 # Environment variables can be used for REMOTE_BACKUP_TARGET and REMOTE_USERNAME | |
12 # | |
13 | |
14 | |
15 container=${1?Must provide container name to backup} | |
16 remoteTarget=${2:-$REMOTE_BACKUP_TARGET} | |
17 userName=${3:-$REMOTE_USERNAME} | |
18 projectDir=${4:-$PWD} | |
19 | |
20 | |
21 cd $projectDir | |
22 | |
23 source "${SSDT_SCRIPTS:-$(dirname "${BASH_SOURCE[0]}")}/.functions.sh" | |
24 | |
25 set -o pipefail | |
26 mkdir -p ./backup | |
27 | |
28 project=$(composeGetProject) | |
29 | |
30 echo "Project is $project" | |
31 echo "Container is $container" | |
32 echo "Remote target is $remoteTarget" | |
33 echo "Username is $userName" | |
34 | |
35 backupFile=./backup/${project}-${container}.$(date +%Y-%m-%d-%H-%M-%S).backup | |
36 backupFile2=./backup/${project}-${container}.$(date +%Y-%m-%d-%H-%M-%S).directorycontents.tar.gz | |
37 | |
38 | |
39 if [ "$project" == "" ]; then | |
40 echo "no project available" | |
41 exit 1 | |
42 fi | |
43 | |
44 echo "starting backup of $container for $project" | |
45 docker-compose exec -T $container sh -c "gosu postgres pg_dump -Cc --if-exists --dbname=$container ; (exit $?) " > ${backupFile} | |
46 | |
47 if [[ $( grep --count "CREATE TABLE" ${backupFile} ) -lt 200 || $( grep --count "PostgreSQL database dump complete" ${backupFile} ) -eq 0 ]]; then | |
48 echo "ERROR: backup verification FAILED" | |
49 echo "ERROR: $(tail ${backupFile})" | |
50 exit 1 | |
51 fi | |
52 | |
53 gzip ${backupFile} | |
54 | |
55 echo "completed backup of $container for $project to ${backupFile}" | |
56 | |
57 #backup of all files in current directory | |
58 tar -czf ${backupFile2} . --exclude=./backup | |
59 | |
60 echo "completed backup of all files for $project to ${backupFile2}" | |
61 | |
62 | |
63 # | |
64 # | |
65 scp ${backupFile}.gz ${backupFile2} $userName@$remoteTarget | |
66 | |
67 echo " " | |
68 | |
69 echo "completed sending ${backupFile}.gz and ${backupFile2} to ${remoteTarget} as user $userName" | |
70 | |
71 |