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

VMware Postgres must write log entries to disk prior to returning operation success or failure.

DISA Rule

SV-239208r717060_rule

Vulnerability Number

V-239208

Group Title

SRG-APP-000226-DB-000147

Rule Version

VCPG-67-000016

Severity

CAT II

CCI(s)

• CCI-001665 - The information system preserves organization-defined system state information in the event of a system failure.

Weight

10

Fix Recommendation

At the command prompt, execute the following commands:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -c "ALTER SYSTEM SET <name> TO 'on';"

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

Note: Substitute <name> with the incorrectly set parameter (fsync, full_page_writes, synchronous_commit)

Check Contents

At the command prompt, execute the following command:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -c "SELECT name,setting FROM pg_settings WHERE name IN ('fsync','full_page_writes','synchronous_commit');"|sed -n '3,5p'|sed -e 's/^[ ]*//'

Expected result:

fsync | on
full_page_writes | on
synchronous_commit | on

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

Vulnerability Number

V-239208

Documentable

False

Rule Version

VCPG-67-000016

Severity Override Guidance

At the command prompt, execute the following command:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -c "SELECT name,setting FROM pg_settings WHERE name IN ('fsync','full_page_writes','synchronous_commit');"|sed -n '3,5p'|sed -e 's/^[ ]*//'

Expected result:

fsync | on
full_page_writes | on
synchronous_commit | on

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

Check Content Reference

M

Target Key

5324

Comments