Postgres user can't create database when running django tests

Question

I've created a user, and given it the required privileges - i.e.

ALTER USER myuser CREATEDB

I can log in to psql as this user and create a database, however when I try to run django tests, I get "permission denied":

$ ./manage.py test
Creating test database for alias 'default'...
Got an error creating the test database: permission denied to create database

I have no such issues in another django project running off the same postgres instance, so something about my django project must be causing the error. The python and django versions are identical.

Any ideas?

You should be myuser when running tests. Maybe you should update DATABASES setting in settings.py for unit tests — Ozgur Vatansever
– Ozgur Vatansever, Commented May 11, 2016 at 4:50
Please check in the test settings if you are using the same myuser. — AKS
– AKS, Commented May 11, 2016 at 4:54
There are no test settings, in fact there aren't even any tests as yet, but I thought django just used the default user for tests anyway? How do I tell which user my tests are using? — Greg
– Greg, Commented May 11, 2016 at 4:58
I'm moron. It was a local settings file and the user in that file didn't have the required permission. — Greg
– Greg, Commented May 11, 2016 at 5:08

Piyush S. Wanare · Accepted Answer · 2016-05-11 10:52:48Z

3

Following steps may help you ,

CREATE DATABASE test_database;
CREATE USER tester WITH PASSWORD 'test_password';
GRANT ALL PRIVILEGES ON DATABASE "test_database" to tester;

answered May 11, 2016 at 10:52

Piyush S. Wanare

4,9836 gold badges41 silver badges55 bronze badges

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

Comments

Greg · Accepted Answer · 2016-05-11 05:10:55Z

1

Make sure you're actually running as the user you think you are - for example, check any local settings files

answered May 11, 2016 at 5:10

Greg

10.4k5 gold badges47 silver badges46 bronze badges

Collectives™ on Stack Overflow

Postgres user can't create database when running django tests

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related