agora inbox for pgsql-committers@postgresql.org
help / color / mirror / Atom feedFrom: Fujii Masao <fujii@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Adjust log level of logical decoding messages by context
Date: Fri, 10 Apr 2026 14:00:35 +0000
Message-ID: <E1wBCPS-000JG2-2t@gemulon.postgresql.org> (raw)
Adjust log level of logical decoding messages by context
Commit 21b018e7eab lowered some logical decoding messages from LOG to DEBUG1.
However, per discussion on pgsql-hackers, messages from background activity
(e.g., walsender or slotsync worker) should remain at LOG, as they are less
frequent and more likely to indicate issues that DBAs should notice.
For foreground SQL functions (e.g., pg_logical_slot_peek_binary_changes()),
keep these messages at DEBUG1 to avoid excessive log noise. They can still be
enabled by lowering client_min_messages or log_min_messages for the session.
This commit updates logical decoding to log these messages at LOG for
background activity and at DEBUG1 for foreground execution.
Suggested-by: Robert Haas <robertmhaas@gmail.com>
Author: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Amit Kapila <amit.kapila16@gmail.com>
Discussion: https://postgr.es/m/CA+TgmoYsu2+YAo9eLGkDp5VP-pfQ-jOoX382vS4THKHeRTNgew@mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/de74d1e9a5453b8efe2eda2afebcf8218a503184
Modified Files
--------------
src/backend/replication/logical/logical.c | 2 +-
src/backend/replication/logical/snapbuild.c | 6 +++---
src/include/replication/logical.h | 21 +++++++++++++++++++++
.../recovery/t/038_save_logical_slots_shutdown.pl | 1 -
4 files changed, 25 insertions(+), 5 deletions(-)
Message-ID: <E1wBCPS-000JG2-2t@gemulon.postgresql.org>
Permalink: ../E1wBCPS-000JG2-2t@gemulon.postgresql.org/
Also on: postgresql.org/message-id/E1wBCPS-000JG2-2t@gemulon.postgresql.org
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: fujii@postgresql.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Adjust log level of logical decoding messages by context
In-Reply-To: <E1wBCPS-000JG2-2t@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox