Re: Odd config issue, cannot set log_min_duration_statement - Mailing list pgsql-admin

From Tom Lane
Subject Re: Odd config issue, cannot set log_min_duration_statement
Date
Msg-id 1624857.1610680146@sss.pgh.pa.us
Whole thread Raw
In response to Re: Odd config issue, cannot set log_min_duration_statement  (S Bob <sbob@quadratum-braccas.com>)
List pgsql-admin
S Bob <sbob@quadratum-braccas.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



pgsql-admin by date:

Previous
From: S Bob
Date:
Subject: Re: Odd config issue, cannot set log_min_duration_statement
Next
From: Yambu
Date:
Subject: Re: Removing second slave server