Loading feed…
Planet PostgreSQL0 Hot0 comments6 min read
All Your GUCs in a Row: log_min_messages, log_min_error_statement, and log_error_verbosity
A deep dive into three interlocking PostgreSQL configuration parameters that govern server-log output: log_min_messages (the severity floor, with its counterintuitive ladder where LOG outranks ERROR), log_min_error_statement (which decides whether the triggering SQL is appended as a STATEMENT: line), and log_error_verbosity (which controls how many fields, like DETAIL, HINT, CONTEXT, and SQLSTATE/LOCATION, each entry prints). The piece walks through real sandbox testing on PostgreSQL 18.6, explains traps like setting log_min_messages to 'log' silently swallowing errors and warnings, and argues the shipped defaults (warning, error, default) are correct for most setups, with terse/panic reserved specifically for compliance scenarios where statement literals or DETAIL fields would leak customer data into logs.
Source: https://postgr.es/p/9ty. 8 Sync News only summarizes and links out; content copyright belongs to the authors and original sources.
Recommended for you
Bình luận
Đang tải bình luận…
