The EDB Postgres Advanced Server must provide an immediate real-time alert to appropriate support staff of all audit failure events requiring real-time alerts.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-224199	EP11-00-008100	SV-224199r879733_rule		Medium

Description
It is critical for the appropriate personnel to be aware if a system is at risk of failing to process audit logs as required. Without a real-time alert, security personnel may be unaware of an impending failure of the audit capability, and system operation may be adversely affected. The appropriate support staff include, at a minimum, the ISSO and the DBA/SA. Alerts provide organizations with urgent messages. Real-time alerts provide these messages immediately (i.e., the time from event detection to alert occurs in seconds or less). The necessary monitoring and alerts may be implemented using features of EDB Postgres, the OS, third-party software, custom code, or a combination of these. The term "the system" is used to encompass all of these.

Description

It is critical for the appropriate personnel to be aware if a system is at risk of failing to process audit logs as required. Without a real-time alert, security personnel may be unaware of an impending failure of the audit capability, and system operation may be adversely affected. The appropriate support staff include, at a minimum, the ISSO and the DBA/SA. Alerts provide organizations with urgent messages. Real-time alerts provide these messages immediately (i.e., the time from event detection to alert occurs in seconds or less). The necessary monitoring and alerts may be implemented using features of EDB Postgres, the OS, third-party software, custom code, or a combination of these. The term "the system" is used to encompass all of these.

STIG	Date
EDB Postgres Advanced Server v11 on Windows Security Technical Implementation Guide	2024-01-24

Details

Check Text ( C-25872r495615_chk )
If Postgres Enterprise Manager (PEM) or another similar monitoring capability is not installed and configured to probe storage volume utilization of "" and notify appropriate support staff upon storage volume utilization reaching capacity, this is a finding. (The default path for the postgresql data directory is C:\Program Files\edb\as\data, but this will vary according to local circumstances.)

Fix Text (F-25860r495616_fix)
Install PEM (or similar tool) and configure a probe to monitor "" and notify appropriate support staff upon storage volume utilization reaching capacity. (The default path for the postgresql data directory is C:\Program Files\edb\as\data, but this will vary according to local circumstances.) Example steps for creating a probe are below, using the thin client (browser) PEM interface. Refer also to the Supplemental Procedures document, supplied with this STIG. Open the PEM web console in a browser. - Log in. - Click on the agent for the machine to be monitored. - Select "Management \| Probe Configuration". - Select "Disk Space" and set the check interval as you like. - Select "Management \| Alerting". - Name the definition "Audit Log Full". - Select Template "Disk Consumption Percentage". - Set Frequency, Comparison Operator, and Thresholds (1 minute, >, 90/95/98 for example). - Enter the Location for the audit log. - Click Notification tab. - Click Email all alerts. - Click Add/Change to save, click "OK" to exit dialog box.

Fix Text (F-25860r495616_fix)

Install PEM (or similar tool) and configure a probe to monitor "" and notify appropriate support staff upon storage volume utilization reaching capacity.

(The default path for the postgresql data directory is C:\Program Files\edb\as\data, but this will vary according to local circumstances.)

Example steps for creating a probe are below, using the thin client (browser) PEM interface. Refer also to the Supplemental Procedures document, supplied with this STIG.

Open the PEM web console in a browser.
- Log in.
- Click on the agent for the machine to be monitored.
- Select "Management | Probe Configuration".
- Select "Disk Space" and set the check interval as you like.
- Select "Management | Alerting".
- Name the definition "Audit Log Full".
- Select Template "Disk Consumption Percentage".
- Set Frequency, Comparison Operator, and Thresholds (1 minute, >, 90/95/98 for example).
- Enter the Location for the audit log.
- Click Notification tab.
- Click Email all alerts.
- Click Add/Change to save, click "OK" to exit dialog box.