# HG changeset patch # User Dave smith # Date 1453148505 18000 # Node ID d8c2d819e814e7f6504a156b0eab2f61ed3b8c1e # Parent 93f2976a6c2f60f924135a5b0e65f738dddb109e add usps restore script diff -r 93f2976a6c2f -r d8c2d819e814 scripts/restore-usps.sh --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/scripts/restore-usps.sh Mon Jan 18 15:21:45 2016 -0500 @@ -0,0 +1,14 @@ + +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