Settings¶
POSTGRES_EXTRA_DB_BACKEND_BASE
DATABASES[db_name]['ENGINE']
must be set to"psqlextra.backend"
. If you’re already using a custom back-end, setPOSTGRES_EXTRA_DB_BACKEND_BASE
to your custom back-end. This will instructdjango-postgres-extra
to wrap the back-end you specified.A good example of where this might be need is if you are using the PostGIS back-end:
django.contrib.gis.db.backends.postgis
.Default value:
django.db.backends.postgresql
Warning
The custom back-end you specify must derive from the standard
django.db.backends.postgresql
.
POSTGRES_EXTRA_AUTO_EXTENSION_SET_UP
You can stop
django-postgres-extra
from automatically trying to enable thehstore
extension on your database. Enabling extensions usingCREATE EXTENSION
requires superuser permissions. Disable this behaviour if you are not connecting to your database server using a superuser.Default value:
True
Note
If set to
False
, you must ensure that thehstore
extension is enabled on your database manually. If not enabled, anyhstore
related functionality will not work.
POSTGRES_EXTRA_ANNOTATE_SQL
If set to
True
, will append a comment to all SQL queries with the path and line number that the query was made from.Format:
/* <pid> <function name> <filename> <line number> */
This can be useful when debugging queries found in PostgreSQL’s
pg_stat_activity
or in its query log.