Re: logging queries

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: logging queries
Дата
Msg-id amp4k6$2f1v$1@news.hub.org
обсуждение исходный текст
Ответ на logging queries  ("Nick Fankhauser" <nickf@ontko.com>)
Список pgsql-admin
Дерево обсуждения 
""Nick Fankhauser"" <nickf@ontko.com> wrote in message
news:NEBBLAAHGLEEPCGOBHDGOEHAFNAA.nickf@ontko.com...
> Hi-
>
> I'd like to set the logging or debug level so that the text of the queries
> that are executed show up in the log file. It seems to me that I recall
this
> being discussed before, but I can't find any specific references in the
> runtime-config portion of the docs.
>
> Can someone tell me if this is possible & if so, what runtime settings are
> needed?

Well,
in    postgresql.conf     put
debug_level = 2
debug_print_query = true


Ciao
Gaetano

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

Предыдущее
От: "Rajesh Kumar Mallah."
Дата:
Сообщение: Re: [DBmirror Issue] recordchange() dies in packageData unless there is a PRIMARY KEY on DELETE and UPDATEs.
Следующее
От: "Mark McEahern"
Дата:
Сообщение: Re: [DBmirror Issue] recordchange() dies in packageData unless thereis a PRIMARY KEY on DELETE and UPDATEs.