title: cannot create extension without superuser role
body: <p>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".</p>
  
  <p>However, when I run tests, it gives me the following error:</p>
  
  <pre><code>$ ./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.
  </code></pre>
  
  <p>The user has the Create DB privilege already, I'm using PostgreSQL 9.1 on Ubuntu 12.04 with Postgis 2.0.</p>