Mercurial > public > ssdt-docker
changeset 28:443aa0be3f09
update backup/restore scripts
| author | smith@nwoca.org |
|---|---|
| date | Mon, 18 Jan 2016 21:28:26 +0000 |
| parents | d8c2d819e814 |
| children | 9cd58674cb56 |
| files | scripts/backup-usas.sh scripts/backup-usps.sh scripts/restore-usas.sh scripts/restore-usps.sh |
| diffstat | 4 files changed, 29 insertions(+), 16 deletions(-) [+] |
line wrap: on
line diff
--- a/scripts/backup-usas.sh Mon Jan 18 15:21:45 2016 -0500 +++ b/scripts/backup-usas.sh Mon Jan 18 21:28:26 2016 +0000 @@ -1,6 +1,6 @@ docker-compose run --rm usasdb sh -c \ - "pg_dump -Cc --host=usasdb \ + "pg_dump -Cc --if-exists --host=usasdb \ --dbname=\$USASDB_ENV_DB_NAME \ --username=\$USASDB_ENV_DB_USER | gzip \ > /backup/\$USASDB_ENV_DB_NAME.$(date +%Y-%m-%d-%H-%M-%S).backup.gz"
--- a/scripts/backup-usps.sh Mon Jan 18 15:21:45 2016 -0500 +++ b/scripts/backup-usps.sh Mon Jan 18 21:28:26 2016 +0000 @@ -1,6 +1,6 @@ docker-compose run --rm uspsdb sh -c \ - "pg_dump -Cc --host=uspsdb \ + "pg_dump -Cc --if-exists --host=uspsdb \ --dbname=\$USPSDB_ENV_DB_NAME \ --username=\$USPSDB_ENV_DB_USER | gzip \ > /backup/\$USPSDB_ENV_DB_NAME.$(date +%Y-%m-%d-%H-%M-%S).backup.gz"
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/scripts/restore-usas.sh Mon Jan 18 21:28:26 2016 +0000 @@ -0,0 +1,13 @@ + +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 usasapp +docker-compose restart usasdb +docker-compose run --rm usasdb sh -c \ + "gunzip -f $1 -c | psql --host=usasdb --username=postgres" +docker-compose start usasapp
--- a/scripts/restore-usps.sh Mon Jan 18 15:21:45 2016 -0500 +++ b/scripts/restore-usps.sh Mon Jan 18 21:28:26 2016 +0000 @@ -1,14 +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 + +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 +docker-compose stop uspsapp