Why is LOG level below WARNING and ERROR for log_min_error_statement?

From: Kal Sze <swordangel(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Why is LOG level below WARNING and ERROR for log_min_error_statement?
Date: 2015-06-05 05:15:33
Message-ID: CAGZiy70q1RM6US73Myr+3zJJA2+69Ut1VfAJZWZh40X3Hi-sig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

I'm trying to debug a problem that is occurring rather rarely, which
causes multiple clients connected to the same postgresql 9.4 server to
crash at the same time.

These clients send *lots* of SQL statements. I want to turn on
statement logging, but I am baffled by the fact that the LOG level is
*below* WARNING and ERROR levels, for the `log_min_error_statement`
configuration option. This results in my log being flooded with
useless messages about statements that have succeeded.

Why is it designed like that?

How do real DBAs deal with that (I'm not a real DBA, just a Python/C#
developer)?

Best Regards,
Kal

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2015-06-05 05:27:31 Re: Why is LOG level below WARNING and ERROR for log_min_error_statement?
Previous Message lmanorders 2015-06-02 17:42:13 Re: DLL Problems