Re: Odd config issue, cannot set log_min_duration_statement

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: S Bob <sbob(at)quadratum-braccas(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Odd config issue, cannot set log_min_duration_statement
Date: 2021-01-15 03:09:06
Message-ID: 1624857.1610680146@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

S Bob <sbob(at)quadratum-braccas(dot)com> writes:
> On 1/14/21 7:53 PM, Tom Lane wrote:
>> IIRC, that means you've applied a setting via ALTER USER,
>> which'd override the default from the config file.

> Yup, that's the last thing I tried:
> postgres=# ALTER SYSTEM SET log_min_duration_statement = 0;

But somewhere you did "ALTER *USER* yourself", and that's
overriding the ALTER SYSTEM for your sessions. ALTER USER RESET
should get rid of that.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Yambu 2021-01-15 07:46:46 Re: Removing second slave server
Previous Message S Bob 2021-01-15 03:01:49 Re: Odd config issue, cannot set log_min_duration_statement