title: Different db for testing in Django?
body: <pre><code>DATABASES = {
  #    'default': {
  #        'ENGINE': 'postgresql_psycopg2',
  #        ...
  #    }
  
      # for unit tests
      'default': {
          'ENGINE': 'django.db.backends.sqlite3',
          'NAME': 'mydatabase'
      }
  }
  </code></pre>
  
  <p>I have two databases: one I'd like to use for unit tests, and one for everything else. Is it possible to configure this in Django 1.2.4?</p>
  
  <p>(The reason I ask is because with postgresql I'm getting the following error:</p>
  
  <pre><code>foo@bar:~/path/$ python manage.py test
  Creating test database 'default'...
  Got an error creating the test database: permission denied to create database
  
  Type 'yes' if you would like to try deleting the test database 'test_baz', or 'no' to cancel: yes
  Destroying old test database...
  Got an error recreating the test database: database "test_baz" does not exist
  </code></pre>
  
  <p>Why could I be getting this error? I guess I don't really care if I can always use SQLite for unit tests, as that works fine.)</p>