Postgres Audit Log Triggers: A Complete Audit Trail for Monoliths
Build a generic Postgres audit log with triggers, a JSONB change history table and session context for user and request IDs, then compare it with Hibernate Envers.
14 min read
Tag
Build a generic Postgres audit log with triggers, a JSONB change history table and session context for user and request IDs, then compare it with Hibernate Envers.
14 min read
Build a generic Postgres audit trigger that records jsonb snapshots and diffs, attributes changes to users, and protects an append-only audit table.
14 min read
Build a trigger-based audit trail in Postgres: JSONB change history table, actor attribution, diffs, protection, querying, partitioning and trade-offs.
14 min read