Use testing.postgresql in the test suite instead of sqlite

[jameshiebert]

Issue #233 has highlighted that our test environment is out of sync with our production environment (the former using sqlite and the latter using postgresql). testing.postgresql postdates this project and mostly mitigates any advantage of using sqlite in the tests. We should use it.