Install
==========

The following steps should be followed to install and configure postgres.

Install postgres 9.3:

    sudo apt-get update
    sudo apt-get install postgresql postgresql-contrib

Configure remote access:

    # open the file and append the lines below
    sudo nano /etc/postgresql/9.3/main/pg_hba.conf
    
    # remote access (where x.x.x.x is your IP)
    host all all x.x.x.x/32 md5
    
    # servers (repeat this line per server)
    host all all x.x.x.x/32 md5

Configure listening:

    # open the file and change the lines below
    sudo nano /etc/postgresql/9.3/main/postgresql.conf
    
    listen_addresses = '*'

Access the psql command line:

    # switch user to the postgres user
    sudo su - postgres
    
    # load the command line
    psql
    
    # create the team city user
    create role teamcity with login password '<password>';
    create database teamcity owner teamcity;

Restart postgres:

    sudo /etc/init.d/postgresql restart