Odd config issue, cannot set log_min_duration_statement

Поиск
Список
Период
Сортировка
От S Bob
Тема Odd config issue, cannot set log_min_duration_statement
Дата
Msg-id 2a31bc9d-5c9b-b76e-083d-c4fb392f0834@quadratum-braccas.com
обсуждение исходный текст
Ответы Re: Odd config issue, cannot set log_min_duration_statement
Re: Odd config issue, cannot set log_min_duration_statement
Список 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



В списке pgsql-admin по дате отправления:

Предыдущее
От: S Bob
Дата:
Сообщение: pgbadger issue
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Odd config issue, cannot set log_min_duration_statement