Ensure the pgcrypto extension is installed and configured correctly

Kako se proverava

Metod provere: Ručni pregled

Ova preporuka se ne može proveriti automatski. Skeniranje je navodi sa ovim uputstvima kada prosledite --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.

Kako se ispravlja

Metod ispravke: Smernica ili zakrpa infrastrukture

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.