In some cases (network connection lost, load balancer issues) the connection to the database is lost without giving Django a notification. Django tries to use such a connection and gets errors because of it. For a correct recovery, we need to restart the application workers.

$ pip install django-postgresql-reconnect

# settings.py

DATABASES = {
    # The database back end that performs reconnect when the connection is closed
    'default': {
        'ENGINE': 'django_postgresql_reconnect.backend',
        'NAME': 'db_name',
        'USER': 'db_user',
        'PASSWORD': 'pwd',
        'HOST': 'db_host',
        'RECONNECT': True,
    },
}

MIDDLEWARE = [
    # Middleware checks and reconnects before processing requests
    'django_postgresql_reconnect.middleware',
    ...
]

For example, in management commands.

import django_postgresql_reconnect

@django_postgresql_reconnect.decorator
def some_awesome_function():
    ...

1. Python 3.8+
2. Install dependencies pip install poetry && poetry install

Check code style: poetry run flake8 Run tests: poetry run pytest

Tests reports are generated in tests/reports.

• out.xml - JUnit test results
• coverage.xml - Coverage xml results

To generate HTML coverage reports use: --cov-report html:tests/reports/cov_html

Django PostgreSQL Reconnect is released under the Apache License Version 2.0.