TMA-POSTGRES-3.1.15

Ensure the correct SQL statements generating errors are recorded

보통레벨 1자동postgres

설명

The log_min_error_statement setting causes all SQL statements generating errors at or above the specified severity level to be recorded in the server log. Each level includes all the levels that follow it. The lower the level (vertically, below), the fewer messages are recorded. Passes when log_min_error_statement is error or a more verbose level. Runs psql as ${PGUSER:-postgres} against ${PGDATABASE:-postgres}; set PGHOST/PGPORT and use ~/.pgpass (not PGPASSWORD, see 1.6/1.7) when peer authentication is not available.

점검 방법

감사 방식: SQL 쿼리

sql_query

out=$(psql -X -U "${PGUSER:-postgres}" -d "${PGDATABASE:-postgres}" -tAc "SELECT CASE WHEN lower(current_setting('log_min_error_statement')) IN ('debug5','debug4','debug3','debug2','debug1','info','notice','warning','error') THEN 'compliant' ELSE 'noncompliant' END" 2>/dev/null) || exit 1; printf '%s\n' "$out"

예상 출력: compliant

조치 방법

조치 방식: SQL 문

shell

psql -X -U "${PGUSER:-postgres}" -c "ALTER SYSTEM SET log_min_error_statement = 'error'" -c "SELECT pg_reload_conf()"

속성

운영 체제: 모두
태그: postgresdatabaselogging
참고 자료: CIS PostgreSQL 18 Benchmark v1.0.0 - 3.1.15 Ensure the correct SQL statements generating errors are recorded

이 호스트 점검하기

감사 권한이 있는 시스템에서 실행하세요. 스캔은 읽기 전용입니다.

shell

tmaegis scan --target postgres