select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Security

pg_roast

Opinionated PostgreSQL database auditor

pgext.cloud · Source code · Documentation · License text · Control file

Overview

Packagepg_roast
Version1.0
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typePreloaded
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableNo
Shared librariespg_roast
Schemaroast
Stars40
Latest commit2026-04-21
Catalogue updated2026-08-30

Related extensions

See also

pgauditprovides auditing functionality
pg_auditorAudit data changes and provide flashback ability
pg_permissionsview object permissions and compare them with the desired state
pgmementoTransaction-based audit trail with schema versioning
table_logrecord table modification logs and PITR for table/row
pgauditlogtofilepgAudit addon to redirect audit log to an independent file
set_usersimilar to SET ROLE but with added logging
pg_snakeoilThe PostgreSQL Antivirus
pg_readonlycluster database read only
pg_command_fwDDL and utility command firewall for PostgreSQL