Re: Odd config issue, cannot set log_min_duration_statement

S Bob <sbob@quadratum-braccas.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