May 6th, 2011 by depesz | Tags: debug_pretty_print, debug_print_parse, debug_print_plan, debug_print_rewritten, logging, logging_collector, log_checkpoints, log_connections, log_destination, log_directory, log_disconnections, log_duration, log_error_verbosity, log_executor_stats, log_filename, log_hostname, log_line_prefix, log_lock_waits, log_min_duration_statement, log_min_error_statement, log_min_messages, log_parser_stats, log_planner_stats, log_rotation_age, log_rotation_size, log_statement, log_statement_stats, log_temp_files, log_timezone, log_truncate_on_rotation, postgresql, silent_mode, syslog_facility, syslog_ident, understanding | 3 comments »
After loooong pause, adding next (well, second) post to the "series". This time, I'd like to describe how logging works. And I don't mean binary logging (WAL), but the log for us, humans, to read. Before I will go to the ...
December 29th, 2009 by depesz | Tags: application_name, environment, guc, logs, log_line_prefix, monitoring, pg85, pg90, postgresql | 10 comments »
On 28th of November Tom Lane committed patch by Dave Page, which adds new capability to system monitoring and logging: Log Message: ----------- Add support for an application_name parameter, which is displayed in pg_stat_activity and recorded in log entries. Dave Page, reviewed by Andres Freund
