#!/bin/bash
#jdevaney July 21, 2010
#dbdumper.sh
#database backup script
#backup all or single databases on a host.
#usage dbdumper hostname db (replace db with "all" to backup all databases on a host)

FILEDATE=`date '+%Y-%m-%d'`
BASEDIR=/u1/$1/db_dumps
PGDUMP=/opt/blackduck/protexIP/postgresql/bin/pg_dump
HOST=$1
DB=$2

RETURN_STATUS=0

if [ $DB == all ]
    then
        for ALLDUMPS in bds_private bds_basic bds_customer bds_template fp_template fp_customer fp_basic
            do
            ssh root@$HOST "env PGUSER=blackduck PGPASSWORD=mallard $PGDUMP -Fc $ALLDUMPS" | pbzip2 > $BASEDIR/$FILEDATE-$HOST-$DUMP.pgsql
                if [ $? -ne 0 ]
                    then RETURN_STATUS=1; mutt -s "dbdumper could not create a backup of $ALLDUMP from $HOST" jdevaney@blackducksoftware.com </dev/null
                fi
            done

    else
        ssh root@$HOST "env PGUSER=blackduck PGPASSWORD=mallard $PGDUMP -Fc $DB" | pbzip2 > $BASEDIR/$FILEDATE-$HOST-$DB.dump.bz2
    if [ $? -ne 0 ]
        then RETURN_STATUS=1 ; mutt -s "dbdumper failed to create a backup of $DB from $HOST" jdevaney@blackducksoftware.com </dev/null
    fi
fi