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.9.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 690a90ed7c01f5622accefb36a418184558628b11bc359c45994b147a9b80c30 |
|
MD5 | 8a2754719ce5e1541a4c6b53d0cdf6d1 |
|
BLAKE2b-256 | 8d0366fc45ab4200c7575918302ea0b0bc0a681f63e0e077804296f030e7049c |