You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
 

10 lines
182 B

#!/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.