Following the instructions of using a Debian 7 image, PostgreSQL 9.1 is installed in /var/lib/postgresql not /opt/postgresql
Merge pull request #145 from jplock/jp-postgres-tarsnap

Tarsnap looking for PostgreSQL in the wrong place
Merge branch 'master' of github.com:do3cc/sovereign