view scripts/backup-usas.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 303259c08b7d
line wrap: on
line source
#!/bin/bash
 docker-compose run --rm usasdb sh -c \
   "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"