Re: Why does log_error_verbosity not apply to server logs? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Why does log_error_verbosity not apply to server logs?
Date
Msg-id ed07ee88-68da-67f7-0bfa-1741a0f48bbc@aklaver.com
Whole thread Raw
In response to Why does log_error_verbosity not apply to server logs?  (Jeremy Finzel <finzelj@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why does log_error_verbosity not apply to server logs?
Next
From: Jeremy Finzel
Date:
Subject: Re: Why does log_error_verbosity not apply to server logs?