view scripts/backup-usps.sh @ 116:4b8eb7301ae0

DEP-12: update to postgres 9.4.11. add script to generate unique postgres password
author smith@nwoca.org
date Thu, 27 Apr 2017 17:51:12 -0400
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"