Mercurial > public > ssdt-docker
annotate scripts/backup-container.sh @ 320:58c49a386a11
making changes to remote backup scripts to create directory
| author | aldrich@ssdt-ohio.org |
|---|---|
| date | Thu, 31 Oct 2019 14:34:53 +0100 |
| parents | d78b45c28205 |
| children | 2cb1093f9aef |
| rev | line source |
|---|---|
| 54 | 1 #!/bin/bash |
| 159 | 2 # Executes a database backup for the specifed database container. |
| 3 # The current directory is expected to contaion 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. The format of the output | |
| 8 # is a compressed pg_dump (sql) format. | |
| 9 # | |
| 10 container=${1?Must provide container name to backup} | |
| 11 | |
| 188 | 12 projectDir=${2:-$PWD} |
| 13 | |
| 14 cd $projectDir | |
| 15 | |
| 159 | 16 source "${SSDT_SCRIPTS:-$(dirname "${BASH_SOURCE[0]}")}/.functions.sh" |
| 17 | |
| 287 | 18 project=$(composeGetProject) |
| 19 | |
| 159 | 20 set -o pipefail |
| 21 mkdir -p ./backup | |
| 314 | 22 ## |
|
320
58c49a386a11
making changes to remote backup scripts to create directory
aldrich@ssdt-ohio.org
parents:
314
diff
changeset
|
23 ##This one puts a space before the IRN |
| 314 | 24 IRN=$(docker-compose exec -T $container psql --username=postgres --dbname=$container -t -c 'select irn from organization') |
| 25 ##Trim function in postgres didn't work - so take out the extra space this way. | |
| 26 IRN=`echo $IRN | sed -e 's/^[[:space:]]*//'` | |
| 159 | 27 |
|
320
58c49a386a11
making changes to remote backup scripts to create directory
aldrich@ssdt-ohio.org
parents:
314
diff
changeset
|
28 ## if database is empty, it will put IRN 000000 |
|
58c49a386a11
making changes to remote backup scripts to create directory
aldrich@ssdt-ohio.org
parents:
314
diff
changeset
|
29 if [ "$IRN" == "" ]; then |
|
58c49a386a11
making changes to remote backup scripts to create directory
aldrich@ssdt-ohio.org
parents:
314
diff
changeset
|
30 echo "no IRN set,using 000000" |
|
58c49a386a11
making changes to remote backup scripts to create directory
aldrich@ssdt-ohio.org
parents:
314
diff
changeset
|
31 IRN=000000 |
|
58c49a386a11
making changes to remote backup scripts to create directory
aldrich@ssdt-ohio.org
parents:
314
diff
changeset
|
32 fi |
|
58c49a386a11
making changes to remote backup scripts to create directory
aldrich@ssdt-ohio.org
parents:
314
diff
changeset
|
33 |
| 314 | 34 backupFile=./backup/${IRN}${project}-${container}.$(date +%Y-%m-%d-%H-%M-%S).backup |
|
320
58c49a386a11
making changes to remote backup scripts to create directory
aldrich@ssdt-ohio.org
parents:
314
diff
changeset
|
35 |
| 314 | 36 echo "IRN${IRN}" |
| 37 | |
| 38 echo "backup file ${backupFile}" | |
| 274 | 39 echo "preparing to backup ${container} on current project at ${projectDir}:" |
| 40 echo " " | |
| 41 | |
|
320
58c49a386a11
making changes to remote backup scripts to create directory
aldrich@ssdt-ohio.org
parents:
314
diff
changeset
|
42 #If the project is empty, we want to stop the process because this is being run from the wrong directory |
| 159 | 43 |
| 44 if [ "$project" == "" ]; then | |
| 45 echo "no project available" | |
| 46 exit 1 | |
| 47 fi | |
| 48 | |
| 49 echo "starting backup of $container for $project" | |
| 188 | 50 docker-compose exec -T $container sh -c "gosu postgres pg_dump -Cc --if-exists --dbname=$container ; (exit $?) " > ${backupFile} |
| 159 | 51 |
| 52 if [[ $( grep --count "CREATE TABLE" ${backupFile} ) -lt 200 || $( grep --count "PostgreSQL database dump complete" ${backupFile} ) -eq 0 ]]; then | |
| 53 echo "ERROR: backup verification FAILED" | |
|
320
58c49a386a11
making changes to remote backup scripts to create directory
aldrich@ssdt-ohio.org
parents:
314
diff
changeset
|
54 echo "Error: empty database" |
| 267 | 55 echo "ERROR: $(tail ${backupFile})" |
|
320
58c49a386a11
making changes to remote backup scripts to create directory
aldrich@ssdt-ohio.org
parents:
314
diff
changeset
|
56 # We want the process to continue even if the db is blank |
|
58c49a386a11
making changes to remote backup scripts to create directory
aldrich@ssdt-ohio.org
parents:
314
diff
changeset
|
57 # exit 1 |
| 159 | 58 fi |
| 59 | |
| 60 gzip ${backupFile} | |
| 61 | |
| 62 | |
| 63 echo "completed backup of $container for $project to ${backupFile}" | |
| 64 |