Re: Odd config issue, cannot set log_min_duration_statement

On 1/14/21 7:53 PM, Tom Lane wrote:
> S Bob <sbob(at)quadratum-braccas(dot)com> 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