cannot create extension without superuser role

Question

I'm trying to run unit tests in Django, and it creates a new database. The database has postgis extensions and when I regularly create the database, I use "CREATE ExTENSION postgis".

However, when I run tests, it gives me the following error:

$ ./manage.py test
Creating test database for alias 'default'...
Got an error creating the test database: database "test_project" already exists

Type 'yes' if you would like to try deleting the test database 'test_project', or 'no' to cancel: yes
Destroying old test database 'default'...
DatabaseError: permission denied to create extension "postgis"
HINT:  Must be superuser to create this extension.

The user has the Create DB privilege already, I'm using PostgreSQL 9.1 on Ubuntu 12.04 with Postgis 2.0.

Answer 1

The Django documentation on postgis has some information on setting up database user privileges.

In the worst case you can create a new database superuser for PostgreSQL:

$ createuser --superuser <user_name>

or alter an existing database user's role:

postgres# ALTER ROLE <user_name> SUPERUSER;