STIGQter: STIG Summary: Crunchy Data Postgres 16 Security Technical Implementation Guide Version: 1 Release: 3 Benchmark Date: 01 Jul 2026:

PostgreSQL must provide audit record generation capability for DOD-defined auditable events within all DBMS/database components.

DISA Rule

SV-261861r1000588_rule

Vulnerability Number

V-261861

Group Title

SRG-APP-000089-DB-000064

Rule Version

CD16-00-000500

Severity

CAT II

CCI(s)

• CCI-000169 - Provide audit record generation capability for the event types the system is capable of auditing as defined in AU-2 a. on organization-defined information system components.

Weight

10

Fix Recommendation

Configure PostgreSQL to generate audit records for at least the DOD minimum set of events.

Using "pgaudit", PostgreSQL can be configured to audit these requests. Refer to supplementary content APPENDIX-B for documentation on installing pgaudit.

To ensure logging is enabled, see the instructions in the supplementary content APPENDIX-C.

Check Contents

Note: The following instructions use the PGLOG environment variables. Refer to supplementary content APPENDIX-I for instructions on configuring PGVER.

Check PostgreSQL audit logs to determine whether organization-defined auditable events are being audited by the system.

For example, if the organization defines 'CREATE TABLE' as an auditable event, issuing the following command should return a result:

$ sudo su - postgres
$ psql -c "CREATE TABLE example (id int)"
$ grep 'AUDIT:.*,CREATE TABLE.*example' ${PGLOG?}/<latest_log>
$ psql -c 'DROP TABLE example;'

If organization-defined auditable events are not being audited, this is a finding.

Vulnerability Number

V-261861

Documentable

False

Rule Version

CD16-00-000500

Severity Override Guidance

Note: The following instructions use the PGLOG environment variables. Refer to supplementary content APPENDIX-I for instructions on configuring PGVER.

Check PostgreSQL audit logs to determine whether organization-defined auditable events are being audited by the system.

For example, if the organization defines 'CREATE TABLE' as an auditable event, issuing the following command should return a result:

$ sudo su - postgres
$ psql -c "CREATE TABLE example (id int)"
$ grep 'AUDIT:.*,CREATE TABLE.*example' ${PGLOG?}/<latest_log>
$ psql -c 'DROP TABLE example;'

If organization-defined auditable events are not being audited, this is a finding.

Check Content Reference

M

Target Key

5598