pgaudit/pgaudit

Health v2 · maintenance only

Flags: no_license

Adoption not part of the score

1709 stars · 196 forks observed · 2026-09-25

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

pgAudit is a PostgreSQL extension written in C that provides detailed session and object audit logging through the standard PostgreSQL logging facility. It produces structured audit trails suitable for government, financial, and ISO certification compliance requirements.

Use cases

• produce audit logs for compliance with government, financial, or ISO certifications
• log all statements that touched a specific table without parsing SQL
• capture DDL statements executed inside DO blocks and functions
• track which user ran which statement against the database
• generate detailed audit trails for database forensics
• log object-level access to sensitive tables

When to choose

• you need detailed, searchable audit logs of PostgreSQL activity for auditors
• standard log_statement=all output is insufficient for compliance requirements
• you need to identify all statements affecting a particular relation
• you must demonstrate object-level access logging for certification

When to avoid

• you only need basic monitoring or debugging of statements
• you cannot tolerate the additional logging volume and performance overhead
• you need audit logging for databases other than PostgreSQL

Facets

plugin · maturity stable

logging security database databases security legal windows self-hosted postgresql-extension audit-logging audit-trail compliance c linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="pgaudit/pgaudit")