TMAegis
Više pravila za postgres

TMA-POSTGRES-6.5

Ensure 'Superuser' Runtime Parameters are Configured

NiskaNivo 1Ručni pregledpostgres

Opis

PostgreSQL runtime parameters that can only be executed by the server's superuser, postgres.

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 name, setting FROM pg_settings WHERE context = 'superuser' ORDER BY 1; and compare with your approved baseline; also check per-role/database overrides (SELECT * FROM pg_db_role_setting;). Any unexpected value is a fail.

Kako se ispravlja

Metod ispravke: Smernica ili zakrpa infrastrukture

Restore approved values in the configuration files (reload), and remove unwanted overrides with ALTER ROLE/ALTER DATABASE ... RESET <parameter>;

Svojstva

Operativni sistemi
Bilo koji
Oznake
postgresdatabaseconfigurationmanual
Referenca
CIS PostgreSQL 18 Benchmark v1.0.0 - 6.5 Ensure 'Superuser' Runtime Parameters are Configured