SV-259169r1210428_rule
V-259169
SRG-APP-000091-DB-000066
VCPG-80-000007
CAT II
10
A script is included with vCenter to generate a PostgreSQL STIG configuration.
At the command prompt, run the following commands:
# chmod +x /opt/vmware/vpostgres/current/bin/vmw_vpg_config/vmw_vpg_config.py
# /opt/vmware/vpostgres/current/bin/vmw_vpg_config/vmw_vpg_config.py --action stig_enable --pg-data-dir /storage/db/vpostgres
# chmod -x /opt/vmware/vpostgres/current/bin/vmw_vpg_config/vmw_vpg_config.py
Note: If this has already been run previously, it does not need to be run again.
Navigate to and edit the /storage/db/vpostgres/stig.conf file.
Add or update the following settings:
pgaudit.log = 'all, -misc, -read'
pgaudit.log_catalog = off
pgaudit.log_parameter = off
pgaudit.log_relation = off
pgaudit.log_statement = off
Remove the following settings:
pgaudit.log_level = log
Restart the PostgreSQL service by running the following command:
# vmon-cli --restart vmware-vpostgres
At the command prompt, run the following commands:
# /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SHOW pgaudit.log;"
If the "pgaudit.log" setting is not configured to "all, -misc, -read", this is a finding.
V-259169
False
VCPG-80-000007
At the command prompt, run the following commands:
# /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SHOW pgaudit.log;"
If the "pgaudit.log" setting is not configured to "all, -misc, -read", this is a finding.
M
5570