Postgres - how to connect?

I remember having the same problem, but I don't remember
the details anymore. Anyway, here's my current database.yml:

  production:
    adapter: postgresql
    database: foo_production
    username: postgres
    password: secret
    host: localhost
    encoding: UTF8

Similar for test and development, _no_ other settings.
(Especially, I think there was a "port" setting that needed to
be removed.)

HTH,
  Stefan