Re: Odd config issue, cannot set log_min_duration_statement

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Odd config issue, cannot set log_min_duration_statement
Дата
Msg-id 1624857.1610680146@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Odd config issue, cannot set log_min_duration_statement  (S Bob <sbob@quadratum-braccas.com>)
Список pgsql-admin
S Bob <sbob@quadratum-braccas.com> writes:
> On 1/14/21 7:53 PM, Tom Lane wrote:
>> IIRC, that means you've applied a setting via ALTER USER,
>> which'd override the default from the config file.

> Yup, that's the last thing I tried:
> postgres=# ALTER SYSTEM SET log_min_duration_statement = 0;

But somewhere you did "ALTER *USER* yourself", and that's
overriding the ALTER SYSTEM for your sessions.  ALTER USER RESET
should get rid of that.

            regards, tom lane



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

Предыдущее
От: S Bob
Дата:
Сообщение: Re: Odd config issue, cannot set log_min_duration_statement
Следующее
От: Yambu
Дата:
Сообщение: Re: Removing second slave server