Force SSL for Django Postgres connection
If you're using dj_database_url you can pass ssl_require=True
which sets the option for you.
import dj_database_url
DATABASES['default'] = dj_database_url.config(ssl_require=True)
Add 'OPTIONS': {'sslmode': 'require'},
to your database config. For example:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql',
'NAME': "db_name",
'USER': "db_username",
'PASSWORD': "db_password",
'HOST': "db_host",
'OPTIONS': {'sslmode': 'require'},
},
}
As jklingen92 points out, if you are using a database URL, such as through django-environ, add ?sslmode=require
to the end of your database URL. For example:
postgres://<DB_USERNAME>:<DB_PASSWORD>@<DB_HOST>:<PORT>/<DB_NAME>?sslmode=require
If you're configuring a database URL, you can pass options as query parameters:
DATABASE_URL=postgres://USER:PASSWORD@HOST:PORT/NAME?sslmode=require
This works with both Django Configurations and with Django Environ.
Django Configurations is built off of dj_database_url
, so you can also pass ssl_require=True
as @frmdstryr said:
DATABASES = values.DatabaseURLValue(environ_required=True, ssl_require=True)