Ubuntu Installation

Server installation

Run this script, editing the variables if you want to use a different username, password, or database name:

USER=domdb
PASSWORD=domdb
DATABASE=domdb
sudo apt-get install -y postgresql-9.3 postgresql-contrib-9.3
sudo -u postgres createuser $USER
sudo -u postgres createdb -O $USER $DATABASE
sudo -u postgres psql -c "ALTER USER $USER WITH ENCRYPTED PASSWORD '$PASSWORD';"
sudo sed -i /etc/postgresql/9.3/main/postgresql.conf -e "s/^#listen_addresses.*/listen_addresses = '*'/"
sudo echo "host $DATABASE $USER 10.0.2.2/16 md5" >> /etc/postgresql/9.3/main/pg_hba.conf
# restart postgres
sudo service postgresql restart

Client installation

Run the following commands:

sudo apt-get update
sudo apt-get install -y git python-sqlalchemy python-pandas python-jinja2 python-psycopg2

In a directory of your choosing, clone the git repository and change directories:

git clone https://github.com/joefutrelle/domdb.git
cd domdb

Now follow the instructions in Installation to configure the client to access your database.