dump the redmine DB from psql and commit it to a git repository

redmine_psql_backup.sh

#!/bin/sh

#
# shell script to dump a database from PostgreSQL and
# store it in git
#
AUTHOR="User <user@host>"
GITCMD="/usr/local/bin/git"
DUMPCMD="/usr/local/bin/pg_dump"
BACKUP_REPO="/path/to/repo"
DUMPFILE="redmine.sql"
DB="NAME_OF_YOUR_REDMINE_DB"

# dump, commit and push
${DUMPCMD} ${DB} > ${BACKUP_REPO}${DUMPFILE}
cd ${BACKUP_REPO}
${GITCMD} add ${DUMPFILE}
${GITCMD} commit -q --author "${AUTHOR}" -m "update redmine dump" 
${GITCMD} push -q origin master