PostgreSQL FATAL: role "<USERNAME>" does not exist

Question

When I bundle exec rake RAILS_ENV=production db:migrate, I get:

rake aborted!
FATAL:  role "<USERNAME>" does not exist

Note that

$ psql  --username=<USERNAME> --dbname=<DATABASE> --password

Does work - which is quite different than the similar questions here.

Any idea what could be the problem ?

Odds are good your production configuration is not connecting to the same server as psql (your local server). Roles in Postgres are global, not database-specific. — Daniel Lyons
– Daniel Lyons, Commented Dec 4, 2013 at 18:23
@DanielLyons I double-checked even with --host=localhost (the same in database.yml). Could be two Postgres instances running on different ports ?! — zakelfassi
– zakelfassi, Commented Dec 4, 2013 at 18:26
Did you specify the port in database.yml? If so, try psql -p <portnum> — Daniel Lyons
– Daniel Lyons, Commented Dec 4, 2013 at 18:33

zakelfassi · Accepted Answer · 2013-12-04 18:42:31Z

2

Thanks @DanielLyons for the head's up.

In fact, I was running two Postgres instances: one was being used by chef-server, on the default port 5432 and the "main one" on port 5433.

$ sudo netstat -plunt |grep postgres
  tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN      571/postgres    
  tcp        0      0 127.0.0.1:5433          0.0.0.0:*               LISTEN      10030/postgres

I just added to my databases.yml file:

port: 5433

And it worked. (Note that this is a hotfix, until I get rid of the chef-server instance.)

answered Dec 4, 2013 at 18:42

zakelfassi

2,9661 gold badge24 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL FATAL: role "<USERNAME>" does not exist

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related