TMA-POSTGRES-3.1.22
Ensure 'log_error_verbosity' is set correctly
NiskaNivo 1Automatskapostgres
Opis
The log_error_verbosity setting specifies the verbosity (amount of detail) of logged messages. Valid values are: ; TERSE ; DEFAULT ; VERBOSE with each containing the fields of the level above it as well as additional fields. TERSE excludes the logging of DETAIL, HINT, QUERY, and CONTEXT error information. Runs psql as ${PGUSER:-postgres} against ${PGDATABASE:-postgres}; set PGHOST/PGPORT and use ~/.pgpass (not PGPASSWORD, see 1.6/1.7) when peer authentication is not available.
Kako se proverava
Metod provere: SQL upit
sql_query
out=$(psql -X -U "${PGUSER:-postgres}" -d "${PGDATABASE:-postgres}" -tAc "SHOW log_error_verbosity" 2>/dev/null) || exit 1; printf '%s\n' "$out"- Očekivani izlaz
verbose
Kako se ispravlja
Metod ispravke: SQL naredba
shell
psql -X -U "${PGUSER:-postgres}" -c "ALTER SYSTEM SET log_error_verbosity = 'verbose'" -c "SELECT pg_reload_conf()"Svojstva
- Operativni sistemi
- Bilo koji
- Oznake
- postgresdatabaselogging
- Referenca
- CIS PostgreSQL 18 Benchmark v1.0.0 - 3.1.22 Ensure 'log_error_verbosity' is set correctly
Proverite ovaj računar
Pokrenite ovo na računaru za koji imate dozvolu za proveru. Skeniranje radi u režimu samo za čitanje.
shell
tmaegis scan --target postgres