Server Setup

There are a number of steps that need to be followed to setup the server correctly. This tutorial assumes Ubuntu Server 14.04 LTS.

First, we will setup the PostgreSQL server.

$ sudo apt-get install postgresql
$ sudo apt-get install postgis*
$ sudo -u postgres createdb "yellrdb"
$ sudo -u postgres psql -d yellrdb-c "CREATE EXTENSION postgis;"
$ sudo -u postgres psql -d yellrdb-c "CREATE EXTENSION postgis_topology;"

You will need to create a user with permissions to the yellrdb database.

Additionally, you may want to reset the database with this command:

$ sudo -u postgres dropdb "yellrdb"; sudo -u postgres createdb "yellrdb"; sudo -u postgres psql -d yellrdb -c "CREATE EXTENSION postgis;"; sudo -u postgres psql -d yellrdb -c "CREATE EXTENSION postgis_topology;"