Re: Logging

Поиск
Список
Период
Сортировка
От Andrew Bartley
Тема Re: Logging
Дата
Msg-id CAA3RN+zwDSvjarTtzKNo1Y++NMcU-LWwZS9JsZs0FM7mfNJu+Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Logging  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: Logging
Список pgsql-general


On Wed, 13 Jun 2018 at 12:43 Laurenz Albe <laurenz.albe@cybertec.at> wrote:
Andrew Bartley wrote:
> Can someone please tell me how to log the values being inserted in this example..
>
> 2018-06-12 22:31:49 UTC-5b2049d4.434ac-STATEMENT:  insert into "api_consumers" ("consumer_id", "create_datetime") values ($1, $2).
>
> I have tried many different logging options and combinations.

That should automatically be logged as a DETAIL message.

log_min_duration_statement = 0
log_min_error_statement = log or better
log_min_messages = log or better

That should do the trick.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
Thanks for the reply Laurenz,


Current settings

"PostgreSQL 9.6.7, compiled by Visual C++ build 1800, 64-bit"
Azure managed instance 


log_min_duration_statement -1
log_min_error_statement DEBUG2
log_min_messages DEBUG2
log_statement ALL
log_error_verbosity VERBOSE

Still no joy.

Thanks Andrew

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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Logging
Следующее
От: "a"
Дата:
Сообщение: How can I retrieve double or int data type for libpq