#!/bin/sh
#
# Script to backup Gerrit installation - "site directory" and database.
#

tar cfj gerrit-site.tar.bz2 /srv/gerrit

# First, backup DB in SQL format
sudo -u postgres pg_dump reviewdb --create --column-inserts >gerrit-reviewdb.sql

# Also, backup DB as raw filesystem snapshot, trivial to restore
# Requires DB be stopped first
service postgresql stop
sleep 2
tar cfj gerrit-postgres.tar.bz2 /var/lib/postgresql/9.*/main
service postgresql start

# Gerrit doesn't like DB connection dropped
#/srv/gerrit/bin/gerrit.sh restart
# Apache likes to negatively cache for too long
#service apache2 restart