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

VMware Postgres must limit the number of connections.

DISA Rule

SV-239196r717045_rule

Vulnerability Number

V-239196

Group Title

SRG-APP-000001-DB-000031

Rule Version

VCPG-67-000001

Severity

CAT II

CCI(s)

• CCI-000054 - The information system limits the number of concurrent sessions for each organization-defined account and/or account type to an organization-defined number of sessions.

Weight

10

Fix Recommendation

At the command prompt, execute the following commands:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -c "ALTER SYSTEM SET max_connections TO '345';"

# /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 max_connections;"|sed -n 3p|sed -e 's/^[ ]*//'

If the returned number is not greater than or equal to 100 and less than or equal to 1000, this is a finding.

Vulnerability Number

V-239196

Documentable

False

Rule Version

VCPG-67-000001

Severity Override Guidance

At the command prompt, execute the following command:

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

If the returned number is not greater than or equal to 100 and less than or equal to 1000, this is a finding.

Check Content Reference

M

Target Key

5324

Comments