django - cannot create extension without superuser role -


i'm trying run unit tests in django, , creates new database. database has postgis extensions , when regularly create database, use "create extension postgis".

however, when run tests, gives me following error:

$ ./manage.py test creating test database alias 'default'... got error creating test database: database "test_project" exists  type 'yes' if try deleting test database 'test_project', or 'no' cancel: yes destroying old test database 'default'... databaseerror: permission denied create extension "postgis" hint:  must superuser create extension. 

the user has create db privilege already, i'm using postgresql 9.1 on ubuntu 12.04 postgis 2.0.

the django documentation on postgis has information on setting user privileges.

in worst case can create new superuser:

$ createuser --superuser <user_name> 

or alter existing user's role:

postgres# alter role <user_name> superuser; 

Comments

Popular posts from this blog

php - cannot display multiple markers in google maps v3 from traceroute result -

php - Boolean search on database with 5 million rows, very slow -

css - Text drops down with smaller window -