Odd config issue, cannot set log_min_duration_statement

From: S Bob <sbob(at)quadratum-braccas(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Odd config issue, cannot set log_min_duration_statement
Date: 2021-01-15 02:12:54
Message-ID: 2a31bc9d-5c9b-b76e-083d-c4fb392f0834@quadratum-braccas.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

All;

I have a client running PostgreSQL v10

I set:

log_min_duration_statement = 0

and restarted the cluster but if I connect via psql and check it's still
disabled

postgres=# show log_min_duration_statement ;
 log_min_duration_statement
----------------------------
 -1
(1 row)

I tried an alter system, now if I cat the auto.conf file i see:

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

However even after another restart It's still disabled:

postgres=# show log_min_duration_statement ;
 log_min_duration_statement
----------------------------
 -1
(1 row)

I grep'ed for the setting in the config file just in case:

$ grep log_min_duration_statement postgresql.conf
log_min_duration_statement = 0          # -1 is disabled, 0 logs all
statements

I'm stumped... Thoughts?

Thanks in advance

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2021-01-15 02:31:40 Re: Odd config issue, cannot set log_min_duration_statement
Previous Message S Bob 2021-01-15 01:42:14 pgbadger issue