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

c# - DetailsView in ASP.Net - How to add another column on the side/add a control in each row? -

javascript - firefox memory leak -

Trying to import CSV file to a SQL Server database using asp.net and c# - can't find what I'm missing -