TMA-POSTGRES-6.11

Ensure the pgcrypto extension is installed and configured correctly

낮음레벨 1수동 검토postgres

설명

PostgreSQL must implement cryptographic mechanisms to prevent unauthorized disclosure or modification of organization-defined information at rest (to include, at a minimum, PII and classified information) on organization-defined information system components.

점검 방법

감사 방식: 수동 검토

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

Run SELECT * FROM pg_available_extensions WHERE name = 'pgcrypto'; If data requires encryption and pgcrypto is not available/installed (installed_version empty), this is a fail. If disk or filesystem encryption is required, have the owners demonstrate it.

조치 방법

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

Install the contrib package if needed and run CREATE EXTENSION pgcrypto; in the databases that store data requiring column-level encryption; keep keys outside the database.

속성

운영 체제: 모두
태그: postgresdatabasecryptomanual
참고 자료: CIS PostgreSQL 18 Benchmark v1.0.0 - 6.11 Ensure the pgcrypto extension is installed and configured correctly