Tests and CI should use postgres

There are (or may be) subtle differences between how sqlite3 and postgres backends work, which break (or may break) the code in ways that are not covered during testing against the other backend. This includes things like automatically truncating varchars (in sqlite3) as opposed to errors (postgres) when saving a too large text.