Mercurial > public > ssdt-docker

view scripts/restore-usps.sh @ 31:ce113c143408

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
set DB_* values directly instead of depending on vars from db service
author smith@nwoca.org
date Tue, 19 Jan 2016 01:10:38 +0000
parents b4ea91a25193
children d8f906afd895
line wrap: on
line source

if [ -z "$1" ]
then
  echo "Usage: `basename $0` {backup file to restore}"
  echo  " filename must relative to the container's file system. (e.g. /backup/filename)"
  exit $E_NOARGS
fi

docker-compose stop uspsapp
docker-compose restart uspsdb
docker-compose run --rm uspsdb sh -c \
   "gunzip -f $1 -c | psql --host=uspsdb --username=postgres"
docker-compose start uspsapp