STIGQter: STIG Summary: VMware vSphere 6.7 PostgreSQL Security Technical Implementation Guide Version: 1 Release: 1 Benchmark Date: 09 Mar 2021:

VMware Postgres must use Coordinated Universal Time (UTC) for log timestamps.

DISA Rule

SV-239215r717066_rule

Vulnerability Number

V-239215

Group Title

SRG-APP-000374-DB-000322

Rule Version

VCPG-67-000023

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 'Etc/UTC';"

# /opt/vmware/vpostgres/current/bin/psql -U postgres -c "SELECT pg_reload_conf();"

Check Contents

At the command prompt, execute the following command:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -c "SHOW log_timezone;"|sed -n 3p|sed -e 's/^[ ]*//'

Expected result:

Etc/UTC

If the output does not match the expected result, this is a finding.

Vulnerability Number

V-239215

Documentable

False

Rule Version

VCPG-67-000023

Severity Override Guidance

At the command prompt, execute the following command:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -c "SHOW log_timezone;"|sed -n 3p|sed -e 's/^[ ]*//'

Expected result:

Etc/UTC

If the output does not match the expected result, this is a finding.

Check Content Reference

M

Target Key

5324

Comments