Re: Odd config issue, cannot set log_min_duration_statement
| От | Tom Lane |
|---|---|
| Тема | Re: Odd config issue, cannot set log_min_duration_statement |
| Дата | |
| Msg-id | 1623237.1610677900@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | Odd config issue, cannot set log_min_duration_statement (S Bob <sbob@quadratum-braccas.com>) |
| Ответы |
Re: Odd config issue, cannot set log_min_duration_statement
|
| Список | pgsql-admin |
S Bob <sbob@quadratum-braccas.com> writes:
> I set:
> log_min_duration_statement = 0
> and restarted the cluster but if I connect via psql and check it's still
> disabled
If you just did "SET" then it'd only affect the current session.
> 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'
Hmm, that should have worked. What do you see in
select * from pg_settings where name = 'log_min_duration_statement';
(the "source..." columns are important here)
regards, tom lane
В списке pgsql-admin по дате отправления: