mamweb/backup_prod_db.sh

11 lines
182 B
Bash
Raw Permalink Normal View History

#!/bin/bash
2015-05-15 15:08:09 +02:00
DBNAME=mam-prod
FNAME=backup-db/$DBNAME-`date '+%F-%T'`.bz2
echo Backing up production DB $DBNAME to $FNAME ...
2015-05-15 15:08:09 +02:00
pg_dump $DBNAME -U mam | bzip2 -9 > $FNAME
echo Done.