TMA-POSTGRES-6.11
Ensure the pgcrypto extension is installed and configured correctly
Description
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.
Méthode de vérification
Méthode d'audit: Revue manuelle
Cette recommandation ne peut pas être vérifiée automatiquement. Une analyse la liste avec ces instructions lorsque vous passez --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.
Méthode de correction
Méthode de correction: Recommandation ou correctif d'infrastructure
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.
Propriétés
- Systèmes d'exploitation
- Tous
- Étiquettes
- postgresdatabasecryptomanual
- Référence
- CIS PostgreSQL 18 Benchmark v1.0.0 - 6.11 Ensure the pgcrypto extension is installed and configured correctly