Optimize Postgres Containers for Testing [RE#15]

Recently, I had this task of transferring our tests from using in-memory SQLite instances to Postgres containers. It seemed a like a pretty straightforward set of changes, until I realized it's not. I had to fix some random unexpected issues down the...