view scripts/backup-usps.sh @ 27:d8c2d819e814

add usps restore script
author Dave smith <smith@nwoca.org>
date Mon, 18 Jan 2016 15:21:45 -0500
parents 727f4cbded5e
children 443aa0be3f09
line wrap: on
line source

 docker-compose run --rm uspsdb sh -c \
   "pg_dump -Cc --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"