view scripts/restore-usps.sh @ 199:ab47ca9899ea

DEP-12: update training db scripts
author smith@nwoca.org
date Mon, 25 Sep 2017 21:50:52 +0100
parents fea886ba7279
children
line wrap: on
line source
#!/bin/bash
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
source "${SSDT_SCRIPTS:-$(dirname "${BASH_SOURCE[0]}")}/.functions.sh"

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