Re: Odd config issue, cannot set log_min_duration_statement

[S Bob <sbob@xxxxxxxxxxxxxxxxxxxxx>]

On 1/14/21 7:53 PM, Tom Lane wrote:

> S Bob <sbob@xxxxxxxxxxxxxxxxxxxxx> writes:
> > On 1/14/21 7:31 PM, Tom Lane wrote:
> > > Hmm, that should have worked.  What do you see in
> > > select * from pg_settings where name = 'log_min_duration_statement';
> > >         
> >       
> > source          | user
> >       
> IIRC, that means you've applied a setting via ALTER USER,
> which'd override the default from the config file.
>
> 			regards, tom lane
>

Yup, that's the last thing I tried:

postgres=# ALTER SYSTEM SET log_min_duration_statement = 0;

and it added the entry in the postgresql.auto.conf file:

$ cat postgresql.auto.conf
# Do not edit this file manually!
# It will be overwritten by the ALTER SYSTEM command.
log_min_duration_statement = '0'

But... it's still -1, even after another restart