view scripts/restore-usps.sh @ 79:85957628f4c0

add script to clear liquibase lock on existing db container
author smith@nwoca.org
date Wed, 06 Apr 2016 19:03:16 +0100
parents 334d65dac778
children fea886ba7279
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

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