Mercurial > public > ssdt-docker

changeset 27:d8c2d819e814

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
add usps restore script
author Dave smith <smith@nwoca.org>
date Mon, 18 Jan 2016 15:21:45 -0500
parents 93f2976a6c2f
children 443aa0be3f09
files scripts/restore-usps.sh
diffstat 1 files changed, 14 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- /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