Re: log_min_messages = warning

On 9/6/22 12:07, Dirschel, Steve wrote:
> We recently upgraded from postgres 12.8 to 14.3.  We are running Aurora
> Postgres on AWS.
>
> We have procedures that will make calls to RAISE NOTICE to write out
> messages if you interactively call the procedure through psql.  These
> procedures are getting called by pg_cron.
>
> Since upgrading these RAISE NOTICE messages are getting written to the
> postgres log file:
>
> For example:
>
> 13:45:00.720882-05
>
> CONTEXT: PL/pgSQL function perf.snap_stats() line 242 at RAISE
>
> 2022-09-06 18:45:01 UTC::@:[21535]:LOG: cron job 2: NOTICE: Snapping
> dba_hist_system_event at 2022-09-06 13:45:00.725818-05
>
> Log_min_messages is set to warning so my understanding is that should
> only log messages at warning, error, log, fatal, or panic.  Any idea how
> to troubleshoot why these are getting written to the log file?

1) Has log_min_messages been commented out?

2) Was the setting changed from something else?

3) If 2) was the server reloaded/restarted to catch the change?

4) Are you sure you are looking at the correct setting?

Try:

select setting, source, sourcefile, pending_restart from pg_settings
where name = 'log_min_messages';

to see if the value is coming from something like an include file.

>
> Thanks
>
> This e-mail is for the sole use of the intended recipient and contains
> information that may be privileged and/or confidential. If you are not
> an intended recipient, please notify the sender by return e-mail and
> delete this e-mail and any attachments. Certain required legal entity
> disclosures can be accessed on our website:
> https://www.thomsonreuters.com/en/resources/disclosures.html

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com