In database.yml, remove unnecessary 'host' option from development and test. On Ubuntu, by default, Postgres requires a password when connecting to 127.0.0.1 but not when using the default Unix sockets.