Rails and PostgreSQL: Role postgres does not exist

Posted by Adam on Stack Overflow See other posts from Stack Overflow or by Adam
Published on 2011-10-23T01:26:18Z Indexed on 2012/12/05 5:04 UTC
Read the original article Hit count: 264

Filed under:
|
|

I have installed postgresql on my Mac OS Lion, and am working on a rails app. I use RVM to keep everything separate from my other rails apps.

For some reason when I try to migrate the db for the first time rake cannot find the postgres user. I get the error

 FATAL:  role "postgres" does not exist

I have pgAdmin 3 so I can clearly see there is a postgres user in the DB - the admin account in fact - so I'm not sure what else to do.

I read somewhere about people having issues with postgresql because of which path it was installed in, but then i don't think i would have gotten that far if it couldn't find the db.

Any clues would be gratefully received!

Thanks, Adam

© Stack Overflow or respective owner

Related posts about ruby-on-rails

Related posts about postgresql