Why is LOG level below WARNING and ERROR for log_min_error_statement?

Поиск
Список
Период
Сортировка
Искать
От
Kal Sze
Тема
Why is LOG level below WARNING and ERROR for log_min_error_statement?
Дата
Msg-id
CAGZiy70q1RM6US73Myr+3zJJA2+69Ut1VfAJZWZh40X3Hi-sig@mail.gmail.com
Список
Дерево обсуждения
Why is LOG level below WARNING and ERROR for log_min_error_statement? Kal Sze <swordangel@gmail.com>
Re: Why is LOG level below WARNING and ERROR for log_min_error_statement? Tom Lane <tgl@sss.pgh.pa.us>
Re: Why is LOG level below WARNING and ERROR for log_min_error_statement? Kal Sze <swordangel@gmail.com>
Re: Why is LOG level below WARNING and ERROR for log_min_error_statement? Kal Sze <swordangel@gmail.com>
Re: Why is LOG level below WARNING and ERROR for log_min_error_statement? amulsul <sul_amul@yahoo.co.in>
Re: Re: Why is LOG level below WARNING and ERROR for log_min_error_statement? Kal Sze <swordangel@gmail.com>
Re: Re: Why is LOG level below WARNING and ERROR for log_min_error_statement? amul sul <sul_amul@yahoo.co.in>
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

В списке pgsql-novice по дате отправления
От: lmanorders
Дата:
Сообщение: Re: DLL Problems
От: Tom Lane
Дата:
FAQ