Ensure the log destinations are set correctly

RendahLevel 1Tinjauan manualpostgres

Deskripsi

PostgreSQL supports several methods for logging server messages, including stderr, csvlog, syslog, and jsonlog. On Windows, eventlog is also supported. One or more of these destinations should be set for server log output.

Cara pemeriksaan

Metode audit: Tinjauan manual

Rekomendasi ini tidak dapat diperiksa secara otomatis. Pemindaian akan menampilkannya beserta petunjuk ini saat Anda memberikan opsi --include-manual.

Run SHOW log_destination; (default stderr) and confirm it contains every destination required by your logging policy (stderr, csvlog, jsonlog, syslog, eventlog). Missing required destinations are a fail.

Cara perbaikan

Metode perbaikan: Panduan atau patch infrastruktur

ALTER SYSTEM SET log_destination = 'csvlog'; (or a comma-separated list such as 'csvlog, syslog') then SELECT pg_reload_conf();

Properti

Sistem operasi: Apa saja
Tag: postgresdatabaseloggingmanual
Referensi: CIS PostgreSQL 18 Benchmark v1.0.0 - 3.1.2 Ensure the log destinations are set correctly