We have always used in memory SQLite databases for testing because anything else is going to have persistence. Between that and mocking model methods, everything should work. There may be a case here that SpatiaLite is needed instead, but it shouldn't need Postgres.