Mercurial > public > ssdt-docker

comparison scripts/backup-container.sh @ 321:2cb1093f9aef

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
making changes to remote backup scripts to account for no IRN
author aldrich@ssdt-ohio.org
date Thu, 31 Oct 2019 14:40:02 +0100
parents 58c49a386a11
children
comparison
equal deleted inserted replaced
320:58c49a386a11 321:2cb1093f9aef
15 15
16 source "${SSDT_SCRIPTS:-$(dirname "${BASH_SOURCE[0]}")}/.functions.sh" 16 source "${SSDT_SCRIPTS:-$(dirname "${BASH_SOURCE[0]}")}/.functions.sh"
17 17
18 project=$(composeGetProject) 18 project=$(composeGetProject)
19 19
20 #If the project is empty, we want to stop the process because this is being run from the wrong directory
21
22 if [ "$project" == "" ]; then
23 echo "no project available"
24 exit 1
25 fi
26
20 set -o pipefail 27 set -o pipefail
21 mkdir -p ./backup 28 mkdir -p ./backup
22 ## 29 ##
23 ##This one puts a space before the IRN 30 ##This one puts a space before the IRN
24 IRN=$(docker-compose exec -T $container psql --username=postgres --dbname=$container -t -c 'select irn from organization') 31 IRN=$(docker-compose exec -T $container psql --username=postgres --dbname=$container -t -c 'select irn from organization')
31 IRN=000000 38 IRN=000000
32 fi 39 fi
33 40
34 backupFile=./backup/${IRN}${project}-${container}.$(date +%Y-%m-%d-%H-%M-%S).backup 41 backupFile=./backup/${IRN}${project}-${container}.$(date +%Y-%m-%d-%H-%M-%S).backup
35 42
36 echo "IRN${IRN}" 43 echo "Project is $project"
44 echo "Container is $container"
45 echo "IRN is $IRN"
37 46
38 echo "backup file ${backupFile}" 47 echo "backup file ${backupFile}"
39 echo "preparing to backup ${container} on current project at ${projectDir}:" 48 echo "preparing to backup ${container} on current project at ${projectDir}:"
40 echo " " 49 echo " "
41 50
42 #If the project is empty, we want to stop the process because this is being run from the wrong directory
43 51
44 if [ "$project" == "" ]; then
45 echo "no project available"
46 exit 1
47 fi
48 52
49 echo "starting backup of $container for $project" 53 echo "starting backup of $container for $project"
50 docker-compose exec -T $container sh -c "gosu postgres pg_dump -Cc --if-exists --dbname=$container ; (exit $?) " > ${backupFile} 54 docker-compose exec -T $container sh -c "gosu postgres pg_dump -Cc --if-exists --dbname=$container ; (exit $?) " > ${backupFile}
51 55
52 if [[ $( grep --count "CREATE TABLE" ${backupFile} ) -lt 200 || $( grep --count "PostgreSQL database dump complete" ${backupFile} ) -eq 0 ]]; then 56 if [[ $( grep --count "CREATE TABLE" ${backupFile} ) -lt 200 || $( grep --count "PostgreSQL database dump complete" ${backupFile} ) -eq 0 ]]; then