'ActiveRecord::NoDatabaseError: FATAL: role "postgres" does not exist when I try to migrate bd in rails

I cloned a friend's git repo and I'm trying to migrate the db. I started postgres, but when I run rails db:migrate, I keep getting the errors:

Rails Error: Unable to access log file.

and

ActiveRecord::NoDatabaseError: FATAL:  role "postgres" does not exist

I've tried all available solutions online but keep getting the same error. Does anyone know what I'm doing wrong?

ruby-on-railspostgresqlactiverecord


Solution 1:[1]

Try the following

Setting Up Postgres Create a Postgres user for the Rails app we'll create in the next step. To do this, switch into the Postgres user:

su - postgres

Then create a user (or a "role", as Postgres calls it):

create role myapp with createdb login password 'password1';

and make sure you have config/database.yml

development:
  adapter: postgresql
  encoding: unicode
  database: myapp_development
  pool: 5
  username: myapp
  password: password1

test:
  adapter: postgresql
  encoding: unicode
  database: myapp_test
  pool: 5
  username: myapp
  password: password1

Solution 2:[2]

The solution for me was:

createuser -s postgres

After I ran that on the command line my rake task to create the DB worked

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Andres23Ramirez
Solution 2 Peter H. Boling

Related Questions