Skip to content

=$
|

  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 16
    • … PostgreSQL 15
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact

Tag: logging_collector

Understanding postgresql.conf : log*

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 postgresql.conf options, let me first describe what happens when PostgreSQL wants to log something.

Continue reading Understanding postgresql.conf : log*

Posted on 2011-05-062013-06-20|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|6 Comments on Understanding postgresql.conf : log*

Search

Follow me

  • Comments RSS
  • Posts RSS

Popular Posts

  • CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03 225 views | 0 comments
  • Explaining the unexplainable – part 3 199 views | 0 comments
  • Explaining the unexplainable – part 2 190 views | 0 comments
  • “ERROR: operator does not exist: integer = text” how to fix it? 168 views | 0 comments
  • Waiting for PostgreSQL 11 – Fast ALTER TABLE ADD COLUMN with a non-NULL default 143 views | 0 comments
  • Explaining the unexplainable 123 views | 0 comments
  • How much RAM is PostgreSQL using? 115 views | 0 comments
  • Using recursive queries to get distinct elements from table 106 views | 0 comments
  • How to run short ALTER TABLE without long locking concurrent queries 105 views | 0 comments
  • Why is UPSERT so complicated? 99 views | 0 comments

PostgreSQL

  • Documentation
  • Explain Analyze analyzer
  • IRC help channel
  • Mailing Lists search
  • PG Planet
  • PostgreSQL Home Page

About me

  • CPAN
  • GitLab
  • Linked In
  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 16
    • … PostgreSQL 15
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact