UCF STIG Viewer Logo

The EDB Postgres Advanced Server must produce audit records containing sufficient information to establish the outcome (success or failure) of the events.


Finding ID Version Rule ID IA Controls Severity
V-213574 PPS9-00-002000 SV-213574r508024_rule Medium
Information system auditing capability is critical for accurate forensic analysis. Without information about the outcome of events, security personnel cannot make an accurate assessment as to whether an attack was successful or if changes were made to the security state of the system. Event outcomes can include indicators of event success or failure and event-specific results (e.g., the security state of the information system after the event occurred). As such, they also provide a means to measure the impact of an event and help authorized personnel to determine the appropriate response.
EDB Postgres Advanced Server Security Technical Implementation Guide 2022-06-13


Check Text ( C-14796r290034_chk )
Execute the following SQL as enterprisedb:

SHOW edb_audit_statement;

If the result is not "all" or if the current setting for this requirement has not been noted and approved by the organization in the system documentation, this is a finding.
Fix Text (F-14794r290035_fix)
Execute the following SQL as enterprisedb:

ALTER SYSTEM SET edb_audit_statement = 'all';
SELECT pg_reload_conf();


Update the system documentation to note the organizationally approved setting and corresponding justification of the setting for this requirement.