Re: Why does log_error_verbosity not apply to server logs?

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Why does log_error_verbosity not apply to server logs?
Дата
Msg-id ed07ee88-68da-67f7-0bfa-1741a0f48bbc@aklaver.com
обсуждение исходный текст
Ответ на Why does log_error_verbosity not apply to server logs?  (Jeremy Finzel <finzelj@gmail.com>)
Список pgsql-general
On 4/22/19 1:30 PM, Jeremy Finzel wrote:
> I have a DO block which is raising a log message with number of rows 
> deleted.  It also shows CONTEXT messages every time, which I don't 
> want.  But setting in the client log_error_verbosity = terse does not 
> work to get rid of the messages.  I can't get it to work even setting it 
> on a per-user level.
> 
> My client shows terse verbosity as expected, but the server logs always 
> no matter what have CONTEXT messages.
> 
> Is there any way to suppress these when called in a DO block like this?

Well the docs:

https://www.postgresql.org/docs/11/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT

say this can only be changed by a superuser.

So are you doing it as a superuser?

Can you show how you are modifying the setting?

> 
> Thanks,
> Jeremy


-- 
Adrian Klaver
adrian.klaver@aklaver.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Why does log_error_verbosity not apply to server logs?
Следующее
От: Jeremy Finzel
Дата:
Сообщение: Re: Why does log_error_verbosity not apply to server logs?