Photo Voltiac Viability Map II

In a previous post I described installing the Photovoltaic Viability Map server software. I got the point where the 'make run' script was failing on connecting to the database.  In this post I'll describe how to get the database setup.

I have installed PostGIS on the Ubuntu 14.04 server using:

$ sudo aptitude install postgresql-9.3-postgis-2.1

There is an init.sql file included with the web app to setup the database:

	/* clean up because I got sick of all this */
	drop table if exists rooftops;
	drop role if exists sunlight;
	/* The role that sunlight will log in as. */
	create role sunlight with password 'H3YCOOLK1D1STH1SYOU' login;
	/* The main table. Stores all the rooftops. */
	create table rooftops (
	id serial primary key,
	shape geometry not null,
	building_area real,
	useable_build_area real,
	percent_usable real,
	kwhs real,
	system_size_kw real,
	savings integer
	);
	grant all privileges on table rooftops to sunlight;
	grant all privileges on rooftops_id_seq to sunlight;

view raw pv_init_sql hosted with ❤ by GitHub

When I run it with:

$ sudo su postgres
$ psql -d postgres -a -f init.sql

I get an error:

psql:init.sql:17: ERROR:  type "geometry" does not exist

A post on stack overflow told me I needed to run:

$ psql -d postgres -c "CREATE EXTENSION postgis;"

After running this, init.sql ran without error, but 'make run' has a new problem:

$ make run
python3 httpserver.py
Traceback (most recent call last):
  File "httpserver.py", line 17, in <module>
    host=app.config["DBHOST"]
  File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 179, in connect
    connection_factory=connection_factory, async=async)
psycopg2.OperationalError: FATAL:  database "test" does not exist

make: *** [run] Error 1

I ran:

$ egrep test *

and found:

flaskconfig.py:DBNAME = 'test'

After changing 'test' to 'postgres', I have a running server:

$ make run
python3 httpserver.py
[15-07-11 11:57:54][NOTE] Starting server
 * Running on http://0.0.0.0:5000/
 * Restarting with reloader
[15-07-11 11:57:54][NOTE] Starting server

Connecting to it from the browser on my desktop machine, I see:

My next task will be to populate the database with data.