TMA-POSTGRES-8.3

Ensure miscellaneous configuration settings are correct

낮음레벨 1수동 검토postgres

설명

This recommendation covers non-regular, special files, and dynamic libraries. PostgreSQL permits local logins via the UNIX DOMAIN SOCKET and, for the most part, anyone with a legitimate Unix login account can make the attempt. Limiting PostgreSQL login attempts can be made by relocating the UNIX DOMAIN SOCKET to a subdirectory with restricted permissions.

점검 방법

감사 방식: 수동 검토

이 권장 사항은 자동으로 점검할 수 없습니다. --include-manual 옵션을 전달하면 스캔 결과에 이 지침과 함께 표시됩니다.

Run SELECT name, setting FROM pg_settings WHERE name IN ('external_pid_file','unix_socket_directories','shared_preload_libraries','dynamic_library_path','local_preload_libraries','session_preload_libraries'); and confirm each value is expected and the referenced files/directories are writable only by postgres/root.

조치 방법

조치 방식: 가이드 또는 인프라 패치

Correct unexpected values in postgresql.conf, restrict permissions on the referenced paths, and restart PostgreSQL.

속성

운영 체제: 모두
태그: postgresdatabaseconfigurationmanual
참고 자료: CIS PostgreSQL 18 Benchmark v1.0.0 - 8.3 Ensure miscellaneous configuration settings are correct