backup_redmine.sh

#!/bin/bash
BACKUP_ROOT="$HOME/redmine_backup"
REDMINE_ROOT="/var/www/redmine"
BACKUP_FILENAME='backup_redmine_'`date +%Y%m%d`'.tar.bz2'
DB_DUMP_FILENAME='db_redmine_'`date +%Y%m%d`'.sqlc'

if [ ! -d "$BACKUP_ROOT" ]; then
    mkdir $BACKUP_ROOT
fi

#backup postgresql database
export PGPASSWORD='xxxxxxxxx'
/usr/bin/pg_dump -U redmine -Fc --file=$BACKUP_ROOT/$DB_DUMP_FILENAME redmine

#backup config, attached files, plugins & assets and themes
tar -cjvPf $BACKUP_ROOT/$BACKUP_FILENAME $REDMINE_ROOT/config $REDMINE_ROOT/files $REDMINE_ROOT/plugins $REDMINE_ROOT/public/themes $REDMINE_$/public/plugin_assets