agora inbox for pgsql-hackers@postgresql.org  

help / color / mirror / Atom feed

From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Chao Li <li.evan.chao@gmail.com>
Cc: Euler Taveira <euler@eulerto.com>
Cc: japin <japinli@hotmail.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: log_min_messages per backend type
Date: Mon, 9 Feb 2026 13:40:51 +0100
Message-ID: <202602091231.ybwsbdbxsbdo@alvherre.pgsql> (raw)
In-Reply-To: <827C26CA-D7C2-4AD9-AEC3-E1E76519453E@gmail.com>

On 2026-Feb-09, Chao Li wrote:

> While it’s reasonable to configure a full comma-separated list in
> postgresql.conf, it seems there’s currently no convenient way for a
> superuser to change the log level of a single process type. For
> example:
> 
> ```
> evantest=# alter system set log_min_messages='backend:debug4';
> ERROR:  invalid value for parameter "log_min_messages": "backend:debug4"
> DETAIL:  Default log level was not defined.
> ```
> 
> This feels a bit inconvenient in practice. Intuitively, it would be
> nice if setting a single type:level could be merged into the existing
> log_min_messages value, rather than requiring users to restate the
> entire configuration.

This has been discussed before and no satisfactory solution has been
found.  You're welcome to spend time thinking on this; see e.g.
https://postgr.es/m/20200928033924.GA998042@toroid.org where not only
the details were discussed, but also some links to other threads about
the same idea were given.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/

view thread (58+ messages)  latest in thread

Message-ID: <202602091231.ybwsbdbxsbdo@alvherre.pgsql>
Permalink:  ../202602091231.ybwsbdbxsbdo@alvherre.pgsql/
Also on:    postgresql.org/message-id/202602091231.ybwsbdbxsbdo@alvherre.pgsql

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-hackers@postgresql.org
  Cc: alvherre@alvh.no-ip.org, li.evan.chao@gmail.com, euler@eulerto.com, japinli@hotmail.com, andres@anarazel.de, pgsql-hackers@lists.postgresql.org
  Subject: Re: log_min_messages per backend type
  In-Reply-To: <202602091231.ybwsbdbxsbdo@alvherre.pgsql>

* 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