Postgres Audit Log Triggers: Change History for a Monolith
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
Tag
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
Design a postgres audit log table, write one generic trigger, pass app user identity safely through poolers, and keep change history usable as it grows.
15 min read