STIGQter: STIG Summary: VMW vRealize Automation 7.x PostgreSQL Security Technical Implementation Guide Version: 1 Release: 1 Benchmark Date: 28 Sep 2018:

The vRA PostgreSQL database must use UTC for log timestamps.

DISA Rule

SV-100041r1_rule

Vulnerability Number

V-89391

Group Title

SRG-APP-000374-DB-000322

Rule Version

VRAU-PG-000300

Severity

CAT II

CCI(s)

• CCI-001890 - The information system records time stamps for audit records that can be mapped to Coordinated Universal Time (UTC) or Greenwich Mean Time (GMT).

Weight

10

Fix Recommendation

At the command prompt, execute the following commands:

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

Check Contents

At the command prompt, execute the following command:

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

If "log_timezone" is not "utc", this is a finding.

Vulnerability Number

V-89391

Documentable

False

Rule Version

VRAU-PG-000300

Severity Override Guidance

At the command prompt, execute the following command:

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

If "log_timezone" is not "utc", this is a finding.

Check Content Reference

M

Target Key

3443

Comments