Mercurial > public > ssdt-docker
view scripts/restore-ess.sh @ 531:9f618d578e10 release/2.17.0
flow: Closed <release> '2.17.0'.
author | Marc Davis <marc.davis@mcoecn.org> |
---|---|
date | Thu, 02 May 2024 22:46:15 -0400 |
parents | e483148f5283 |
children | 6f7ae8d659cf |
line wrap: on
line source
#!/bin/bash source "${SSDT_SCRIPTS:-$(dirname "${BASH_SOURCE[0]}")}/.functions.sh" sourceFile=${1?must provide backup file to be restored} if [ -z "$1" ] then echo "Usage: `basename $0` {backup file to restore}" echo " must specify the name of the file to restore. Assumed to be in format:" echo " {entityId}-ess-db.{timestamp}.backup.gz " exit $E_NOARGS fi function prop { grep "${1}" .env/ess-shared.properties|cut -d'=' -f2 } entityId=$(prop 'entityId' | tr -d '"') dbContainerName="$entityId-ess-db" appContainerName="$entityId-ess-app" target="essdb" echo echo "Preparing to restore" echo "--------------------" echo " file: $sourceFile" echo " to $dbContainerName database: $target" echo " " echo "WARNING: This operation will DELETE and replace any exising database" echo " " read -e -p "Continue? <y/N> " answer case $answer in y | Y | yes | YES ) answer="y";; n | N | no | NO ) answer="n";; *) answer="n" esac if [ "$answer" == "y" ] then echo "stopping application service $appContainerName" docker stop $appContainerName echo "copy backup file to database container" docker cp ${sourceFile} ${dbContainerName}:/tmp/restore.backup.gz echo "starting database restore" docker exec -t -u postgres $dbContainerName sh -c "gunzip -f /tmp/restore.backup.gz -c | psql" fi