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