django can't drop the test DB via pgbouncer

Question

I'm using pgbouncer with Django. I've added test_foo database to its config to be able to run tests, because apparently Django can't use a different port for the test DB. Now the test run but at the end, when Django tries to drop the test DB, I receive

django.db.utils.DatabaseError: database "test_foo" is being accessed by other users
DETAIL:  There are 1 other session(s) using the database.

I suppose that is caused by the open connection stored by pgbouncer. What can I do?

This is such a frustrating problem.

orokusaki
– orokusaki

2013-08-21 00:31:45 +00:00
Commented Aug 21, 2013 at 0:31 — orokusaki
– orokusaki, Commented Aug 21, 2013 at 0:31

Dick · Accepted Answer · 2011-11-18 20:09:29Z

9

This is not the perfect solution, but it does the trick. You can force Django to use different database settings when running unit tests by adding to your settings.py:

if 'test' in sys.argv or 'test_coverage' in sys.argv:    
    # Use 5432 as db port (avoid going through pgbouncer, can't delete test DB).
    DATABASES = {
        'default': {
            'ENGINE': 'django.contrib.gis.db.backends.postgis',
            'NAME': 'xxx',
            'USER': 'xxx',
            'PASSWORD': 'xxx',
            'HOST': '',
            'PORT': '5432'
        },
    }

answered Nov 18, 2011 at 20:09

Dick

1,23813 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

RichVel Over a year ago

great answer, works fine. Small tweak: write the code like this to just change port number, assuming this is after your normal DATABASES setting: if 'test' in sys.argv or 'test_coverage' in sys.argv: DATABASES['default']['PORT'] = 5432

Collectives™ on Stack Overflow

django can't drop the test DB via pgbouncer

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related