PSQL Connect Issues

Question

Ever since I installed pgAdmin 4, I've been getting issues with Rails projects. Just like this one:

FATAL:  permission denied for database "postgres"
DETAIL:  User does not have CONNECT privilege.
Couldn't create 'db_name' database. Please check your configuration.
rails aborted!
ActiveRecord::NoDatabaseError: FATAL:  permission denied for database "postgres"
DETAIL:  User does not have CONNECT privilege.

The steps I've done to fix the issues are:

GRANT CONNECT ON DATABASE db_name TO user_name;


GRANT ALL PRIVILEGES ON DATABASE db_name TO user_name;

But I still am getting the error above every time I run rails db:setup. What's happening?

andre aliaman · Accepted Answer · 2020-04-04T15:51:22.177

1

Do you already try with give permisison to the schema also?

GRANT USAGE ON SCHEMA schemaname TO username;

I got from this link if you want to learn further.

edited Apr 04 '20 at 15:51

answered Apr 04 '20 at 15:43

andre aliaman

26
2

score -1 · Answer 2 · edited Jun 20 '20 at 09:12

-1

FATAL: permission denied for database "postgres"

GRANT CONNECT ON DATABASE db_name TO user_name;

You need to GRANT CONNECT to the database you are trying to connect to. Based on the error message, that would be "postgres", not "db_name".

Or change the config so you don't try to connect to "postgres" in the first place.

edited Jun 20 '20 at 09:12

Community

1
1

answered Apr 04 '20 at 12:49

jjanes

37,812
5
27
34

I ran this but I still wasn't able to run the `rails db:setup` : `GRANT CONNECT ON DATABASE "db_name" TO "user_name";` – Vicente Antonio G. Reyes Apr 04 '20 at 12:54
"db_name" and "postgres" are different things. Even when in double quotes. – jjanes Apr 04 '20 at 12:56
Those are just pseudo names of the real db name and username. C'mon. – Vicente Antonio G. Reyes Apr 04 '20 at 13:13
Are the real names of "postgres" and "db_name" equal to each other? If you falsify your ERROR messages, it is up to you to translate our advice back into reality. Note that those are both attempted database names, neither one of them is a username. – jjanes Apr 04 '20 at 13:59

PSQL Connect Issues

2 Answers2