view scripts/restore-usps.sh @ 27:d8c2d819e814

add usps restore script
author Dave smith <smith@nwoca.org>
date Mon, 18 Jan 2016 15:21:45 -0500
parents
children 443aa0be3f09
line wrap: on
line source

f [ -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 run --rm uspsdb sh -c \
   "gunzip -f $1 -c | psql  --host=uspsdb \
      --dbname=\$USPSDB_ENV_DB_NAME \
	  --username=\$USPSDB_ENV_DB_USER"
docker-compose stop uspsapp