log_min_messages = warning

Поиск
Список
Период
Сортировка
Искать
От
Dirschel, Steve
Тема
log_min_messages = warning
Дата
Msg-id
DM6PR03MB433216774DF79FF496ADB14DFA7E9@DM6PR03MB4332.namprd03.prod.outlook.com
Список
Дерево обсуждения
log_min_messages = warning "Dirschel, Steve" <steve.dirschel@thomsonreuters.com>
Re: log_min_messages = warning Adrian Klaver <adrian.klaver@aklaver.com>
RE: [EXT] Re: log_min_messages = warning "Dirschel, Steve" <steve.dirschel@thomsonreuters.com>
Re: [EXT] Re: log_min_messages = warning Tom Lane <tgl@sss.pgh.pa.us>
RE: [EXT] Re: log_min_messages = warning "Dirschel, Steve" <steve.dirschel@thomsonreuters.com>
Re: [EXT] Re: log_min_messages = warning Tom Lane <tgl@sss.pgh.pa.us>
RE: [EXT] Re: log_min_messages = warning "Dirschel, Steve" <steve.dirschel@thomsonreuters.com>
Re: [EXT] Re: log_min_messages = warning Tom Lane <tgl@sss.pgh.pa.us>
Re: [EXT] Re: log_min_messages = warning Junwang Zhao <zhjwpku@gmail.com>

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?

 

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
В списке pgsql-general по дате отправления
От: Jeffrey Walton
Дата:
От: Levi Aul
Дата:
FAQ