Like I said there is a place for mocks. I haven't worked with the 3 tools you named, but I find that sqlite in-memory databases are easy to setup in my tests.

I don't consider the distinction between unit and integration tests useful. If the bug is in Postgress then I want to find that out, and I care if the test is technically an integration test, I care that my software doesn't work.