backup bucky
#!/bin/sh
BACKUPDIR=/Users/developer/backup/bucky/production/
DAYSTAMP=`date "+%d"`
HOURSTAMP=`date "+%H"`
DAYFILE="daily_$DAYSTAMP.dump"
HOURFILE="hourly_$HOURSTAMP.dump"
DAYPATH=$BACKUPDIR$DAYFILE
HOURPATH=$BACKUPDIR$HOURFILE
SSH_USER="bucky_box"
SSH_SERVER="bbs"
SSH_KEY="id_rsa"
if [ ! -d "$BACKUPDIR" ]; then
echo Creating directory $BACKUPDIR
mkdir -p $BACKUPDIR
fi
echo As user $USER writing dump from prod to $HOURPATH
ssh $SSH_USER@$SSH_SERVER -i ~/.ssh/$SSH_KEY -C "pg_dump -U bucky_box -i -F c -b bucky_box_production" > $HOURPATH
if [ 10 == $HOURSTAMP ]; then
echo Writing dump from prod to $DAYPATH
cp $HOURPATH $DAYPATH
fi
echo Done.