Permission denied error with PostgreSQL and Django. Giving rights to PostgreSQL user admin

Question

I have Django app with PostgreSQL.

The app has those environment variables:

DATABASE_HOST=localhost
DATABASE_USER=admin
DATABASE_PASSWORD=admin

Here is psql output:

postgres=# CREATE USER admin WITH PASSWORD 'admin123';
ERROR:  role "admin" already exists


postgres=# select * from USER;
 current_user
--------------
 postgres
(1 row)

postgres=# GRANT ALL privileges ON DATABASE my_db to admin;                 
GRANT

When I try to take something from db I get ProgrammingError: permission denied for relation app_rangeslot.

So, the questions:

1) If user admin have all rights, why I get permission denied error?

2) If user admin is created, why I cannot see it?

Which django version are you using and can write the value of DATABASES — Mohammad Mustaqeem
– Mohammad Mustaqeem, Commented Nov 23, 2017 at 17:00
@MohammadMustaqeem Django version is 1.8 DATABASES = { 'my_db': { 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': os.getenv('DATABASE_NAME', 'my_dev'), 'USER': os.getenv('DATABASE_USER', 'postgres'), 'PASSWORD': os.getenv('DATABASE_PASSWORD', os.getenv('DATABASE_PASSWORD', '')), 'HOST': os.getenv('DATABASE_HOST', os.getenv('DATABASE_HOST', '')), 'PORT': '5432', } } — v18o
– v18o, Commented Nov 23, 2017 at 17:07

Mohammad Mustaqeem · Accepted Answer · 2017-11-23 17:19:57Z

1

I think you are missing 'default' key in the DATABASES dict. Your settings should be as given below:

DATABASES = {
  'default': {
      'ENGINE': 'django.db.backends.postgresql_psycopg2',
      'NAME': os.getenv('DATABASE_NAME', 'my_dev'),
      'USER': os.getenv('DATABASE_USER', 'postgres'),
      'PASSWORD': os.getenv('DATABASE_PASSWORD', ''),
      'HOST': os.getenv('DATABASE_HOST', ''),
      'PORT': '5432',
  }
}

answered Nov 23, 2017 at 17:19

Mohammad Mustaqeem

1,0846 silver badges11 bronze badges

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

1 Comment

v18o Over a year ago

No, default is occupied with another db. I have 2 db in one app. And the default db work just fine.

Neil Anderson · Accepted Answer · 2017-11-24 02:12:34Z

0

I think you are connected as the postgres user

      'USER': os.getenv('DATABASE_USER', 'postgres'),

don't you want to actually connect as the admin?

      'USER': os.getenv('DATABASE_USER', 'admin'),

answered Nov 24, 2017 at 2:12

Neil Anderson

1,39512 silver badges19 bronze badges

Collectives™ on Stack Overflow

Permission denied error with PostgreSQL and Django. Giving rights to PostgreSQL user admin

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related