Ensure 'debug_print_rewritten' is disabled

낮음레벨 1자동postgres

설명

The debug_print_rewritten setting enables printing the query rewriter output for each executed query. These messages are emitted at the LOG message level. Unless directed otherwise by your organization's logging policy, it is recommended this setting be disabled by setting it to off. 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 "SHOW debug_print_rewritten" 2>/dev/null) || exit 1; printf '%s\n' "$out"

예상 출력: off

조치 방법

조치 방식: SQL 문

shell

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

속성

운영 체제: 모두
태그: postgresdatabaselogging
참고 자료: CIS PostgreSQL 18 Benchmark v1.0.0 - 3.1.17 Ensure 'debug_print_rewritten' is disabled

이 호스트 점검하기

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

shell

tmaegis scan --target postgres