Postgres support for Transition apps

Adds the same module we use in GOV.UK puppet and then creates a database
for the Transition app to use.
Minor point but might this be better as a `FIXME`? Simply for the reason that that's what I'd usually search for and a quick GitHub search shows we're not using `TODO` anywhere else.