On 8/19/2011 9:01 AM, Adrian Klaver wrote:
On Friday, August 19, 2011 6:55:39 am Andy Colson wrote:
As of now, I am trying with logging level set to debug5 in
postgresql.conf for all logging options. But what is the 'correct'
approach?
Regards,
Jayadevan
Not sure what the exact setting is, try:
log_statement = 'all'
I've never set the log_min_messages or log_min_error_statement, and I'm
pretty sure I've seen values in my logs.
If I remember correctly this is version specific, though I cannot remember what
version the actual variables where made visible:(
Ah, yeah, you are probably right.
I can confirm in PG 9, with just
>> log_statement = 'all'
I see things like:
DETAIL: parameters: $1 = '%oak%'
in my log.
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
