Horton
Menu

Re: log_min_messages per backend type

Euler Taveira <euler@eulerto.com>

View thread
From: "Euler Taveira" <euler@eulerto.com>
To: "surya poondla" <suryapoondla4@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2026-02-07T01:05:28Z
Lists: pgsql-hackers 
On Fri, Feb 6, 2026, at 5:28 PM, surya poondla wrote:
>
> Quick clarification on how this feature interacts with existing 
> per-session and per-role/database GUC settings:
> If I set log_min_messages = 'warning, backend:error' at the cluster 
> level:
>   1. Can an individual session still override this with SET 
> log_min_messages = DEBUG1?
>   2. Do role/database-level settings (e.g., ALTER ROLE alice SET 
> log_min_messages = DEBUG1) still work as expected?
>

Yes. Yes.

> I assume both would override the cluster-level backend:error setting 
> following standard GUC precedence rules, but wanted to confirm.
>

This feature doesn't change the GUC context.

postgres=# show log_min_messages;
    log_min_messages    
------------------------
 warning, backend:error
(1 row)

another terminal:

(gdb) p log_min_messages[0]@18
$16 = {19, 21, 19 <repeats 16 times>}

8<-----------------------------------------------------------------8<

postgres=# set log_min_messages to debug1; 
SET

another terminal:

(gdb) p log_min_messages[0]@18
$17 = {14 <repeats 18 times>}

8<-----------------------------------------------------------------8<

postgres=# reset log_min_messages;
RESET

another terminal:

(gdb) p log_min_messages[0]@18
$18 = {19, 21, 19 <repeats 16 times>}


-- 
Euler Taveira
EDB   https://www.enterprisedb.com/

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Cleanup for log_min_messages changes in 38e0190ced71

  2. Allow log_min_messages to be set per process type

  3. Assign "backend" type earlier during process start-up

  4. Use integer backend type when exec'ing a postmaster child

  5. Sort guc_parameters.dat alphabetically by name

  6. Create a separate file listing backend types

  7. Replace postmaster.c's own backend type codes with BackendType