QuestionQ54

Log Management

You work as a SOC analyst for a cloud-based service provider that uses PostgreSQL databases to hold critical customer data. During a recent security review, you find that logs are not generated for failed authentication attempts, slow queries, or database errors. This lack of visibility makes it difficult to detect potential threats and investigate suspicious database activity. To ensure PostgreSQL captures and stores logs for centralized monitoring and forensic analysis, which configuration parameter should be enabled?

  • A log_collector
  • B loggingcollector
  • C logging_collector
  • D logging-collector
Explanation

logging_collector enables PostgreSQL’s logging collector background process, which captures messages sent to standard error and redirects them into log files for retention and centralized monitoring. Logging the specified event types may also require related settings such as log_connections, log_min_duration_statement, and error-level configuration.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!