Create a test database and populate it with the test schema.

createdb pgxdata
psql pgxdata -f test/structure.sql

Set PG* envvars when running tests to pass connection information to tests.

PGHOST=/var/run/postgresql PGDATABASE=pgxdata rake

Regenerate the test app in test/data as needed (probably need to automate this).