PG::ConnectionBad: could not translate host name error after running export DATABASE_URL=postgres://$(whoami)

....And the answer you've all been waiting for:

If you've messed up your development environment by running export DATABASE_URL=..., if you'e in a similar sitaution to the one above and already set up your environments within each project, resolve this issue by running

unset DATABASE_URL