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.klaver@aklaver.com