Re: logging queries

""Nick Fankhauser"" <nickf(at)ontko(dot)com> wrote in message
news:NEBBLAAHGLEEPCGOBHDGOEHAFNAA(dot)nickf(at)ontko(dot)com(dot)(dot)(dot)
> 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