Why is it "test" instead of "testing" in the database.yml? It seems to me pretty plain that it should be "testing" in order to remain consistent with the other 2: development and production. E.g. you could think about it as development phase, testing phase, production phase vs. develop, test, and, well, produce doesn't really make sense but that's irrelevant.
Reason I ask is cus I encountered an "adapter not specified" when trying to run rspec after switching to postgresql and hence modifying my database.yml file and the problem was that I unthinkingly wrote "testing" instead of "test".