Re: Why does log_error_verbosity not apply to server logs?

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(dot)klaver(at)aklaver(dot)com