Postgres audit triggers for Django
Project description
Postgres audit database via triggers
This app sets up a postgres audit database via triggers. See https://wiki.postgresql.org/wiki/Audit_trigger_91plus and https://github.com/2ndQuadrant/audit-trigger/ for more information.
Installation
pip install postgres_audit_triggers
Usage
Add the postgres_audit_triggers app to INSTALLED_APPS before any apps that will be audited:
# settings.py INSTALLED_APPS = { 'postgres_audit_triggers', ... }
Run migrations: python manage.py migrate postgres_audit_triggers
Add audit_trigger = True to the Model Meta options of the models that will be audited:
# models.py class MyAuditedModel(models.Model): ... class Meta: audit_trigger = True ...
Make migrations: python manage.py makemigrations
Run migrations: python manage.py migrate
Triggers introduce performance overhead. In certain cases, you may need to disable triggers while performing bulk operations. To turn off all triggers, a decorator is provided:
from postgres_audit_triggers.decorators import disable_triggers @disable_triggers def foo(): # auditing will not be triggered on any database operations performed here Bar.objects.bulk_create(items)
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Hashes for postgres_audit_triggers-0.1.10.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8dd282d52537c872204564a2c9af14a482057d863d88133986aedd5b0168d0c4 |
|
MD5 | f68288ddf19783722a4d8a95ca8d5a86 |
|
BLAKE2b-256 | 65a781615fcf55d1080903a135ee685d414a153af1151862cbc29f4e709cf2aa |