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