mamweb/backup_prod_db.sh
2015-05-15 15:08:09 +02:00

10 lines
182 B
Bash
Executable file

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