STIGQter: STIG Summary: VMware vSphere 7.0 vCenter Appliance PostgreSQL Security Technical Implementation Guide Version: 1 Release: 2 Benchmark Date: 26 Jul 2023:

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

DISA Rule

SV-256604r887598_rule

Vulnerability Number

V-256604

Group Title

SRG-APP-000226-DB-000147

Rule Version

VCPG-70-000014

Severity

CAT II

CCI(s)

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

Weight

10

Fix Recommendation

At the command prompt, run the following commands for each setting returned as "off" in the check:

# /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, run the following command:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SELECT name,setting FROM pg_settings WHERE name IN ('fsync','full_page_writes','synchronous_commit');"

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-256604

Documentable

False

Rule Version

VCPG-70-000014

Severity Override Guidance

At the command prompt, run the following command:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SELECT name,setting FROM pg_settings WHERE name IN ('fsync','full_page_writes','synchronous_commit');"

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

5521