← Back to EnterpriseDB Postgres Advanced Server (EPAS) Security Technical Implementation Guide

V-259316

CAT II (Medium)

The EDB Postgres Advanced Server must generate audit records when successful logons or connections occur.

Rule ID

SV-259316r961824_rule

STIG

EnterpriseDB Postgres Advanced Server (EPAS) Security Technical Implementation Guide

Version

V2R1

CCIs

CCI-000172

Discussion

For completeness of forensic analysis, it is necessary to track who/what (a user or other principal) logs on to the DBMS.

Check Content

Execute the following SQL as the "enterprisedb" operating system user:

> psql edb -c "SHOW edb_audit_connect"

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

Execute the following SQL as the "enterprisedb" operating system user:

> psql edb -c "ALTER SYSTEM SET edb_audit_connect = 'all'"
> psql edb -c "ALTER SYSTEM SET edb_audit_disconnect = 'all'"
>psql edb -c "SELECT pg_reload_conf()"

or

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