Re: log_min_messages per backend type - Mailing list pgsql-hackers

From Euler Taveira
Subject Re: log_min_messages per backend type
Date
Msg-id 083656a8-b389-4a69-9514-7ce7b8144770@app.fastmail.com
Whole thread Raw
In response to Re: log_min_messages per backend type  (surya poondla <suryapoondla4@gmail.com>)
List 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/



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Windows locales and tests portability
Next
From: Tom Lane
Date:
Subject: Re: Decoupling our alignment assumptions about int64 and double