Re: Log msg - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: Log msg
Date
Msg-id 40A946D7.2060508@bigfoot.com
Whole thread Raw
In response to Log msg  ("Jie Liang" <jie@stbernard.com>)
List pgsql-admin
Jie Liang wrote:

> Hi,All,
>
>
> How to config log file to log statement without CONTEXT stuff? I want
> log query, but not the detail unless there is a problem,
> e.g. Delete aaa from mytable where mysqlfunction(bbb);
> I want log this statement,
> but not any CONTEXT inside mysqlfunction, because it will easily filled
> up my disk if mytable have millions of entries, meanwhile, the log file
> become useless.
> But if I set log_statement = true, log file will log millions of
> statement in mysqlfunction, but I set log_statement=false, log file
> won't log query at all.
> Simply say, I want log what I execute(my query), but not how execute
> (process) .

Decrease the verbosity of your logs using:

log_error_verbosity = terse


Regards
Gaetano Mendola






pgsql-admin by date:

Previous
From: Duane Lee - EGOVX
Date:
Subject: Hardware Platform
Next
From: Peter Eisentraut
Date:
Subject: Re: How to determine if ODBC was compiled in?