← Back to VMW vRealize Automation 7.x PostgreSQL Security Technical Implementation Guide

V-240329

CAT II (Medium)

The vRA PostgreSQL database must set log_connections to on.

Rule ID

SV-240329r879876_rule

STIG

VMW vRealize Automation 7.x PostgreSQL Security Technical Implementation Guide

Version

V1R2

CCIs

CCI-000172

Discussion

For completeness of forensic analysis, it is necessary to know how long a user's (or other principal's) connection to the DBMS lasts. This can be achieved by recording disconnections, in addition to logons/connections, in the audit logs. Disconnection may be initiated by the user or forced by the system (as in a timeout) or result from a system or network failure. To the greatest extent possible, all disconnections must be logged.

Check Content

At the command prompt, execute the following command:

# grep '^\s*log_connections\b' /storage/db/pgdata/postgresql.conf

If "log_connections" is not "on", this is a finding.

Fix Text

At the command prompt, execute the following commands:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -c "ALTER SYSTEM SET log_connections TO 'on';"
# /opt/vmware/vpostgres/current/bin/psql -U postgres -c "SELECT pg_reload_conf();"